1 / 12

Power-BI-January-Feature-Summary-2023

List of Power BI January Updates

Vijayraghavan2020
Download Presentation

Power-BI-January-Feature-Summary-2023

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Source:https://powerbi.microsoft.com/en-ca/blog/power-bi-report-server-january-2023-feature-summary/Source:https://powerbi.microsoft.com/en-ca/blog/power-bi-report-server-january-2023-feature-summary/ 1

  2. Full list of January Updates:  Report Server  Reporting  Modeling 2

  3. Reporting Power BI Report Server accent color update  Power BI announced the upcoming change in color accent to teal. This change was made to ensure our product is more accessible for users with disabilities. The new color improves contrast and increases visibility of the user interfacein PowerBI. Publish .rdl &.pbixfiles to Power BI from Power BI Report Server  Another added benefit with this change is the new mobile formatting options now have access to this setting too! Users can quickly update their mobile layoutslicersto use tileto be more mobilefriendly. 3

  4. Reporting  You can migrate reportswithout Report Serverdowntime or disruption to your report users. It’s important to understand that you don’t need to remove any data or reports. You can keep your current environment in place until you’re ready for it to be retired. Reverse stack order for stacked column charts  You can now reverse the order in which we render segments in stacked column and bar charts. This can be particularly helpful to help users match the category groupings of strictly positive columns against vertically aligned legends. 4

  5. Reporting Query performance improvements Indexing imported string columns on-the-fly​ Build the index when the first query that requests a substring search on the column is executed. The index is built for text columns that contain ASCII characters only. Once the index is built, substring search becomes instant. Note that the index is not persisted between restarts of Power BI Desktop. 5

  6. Reporting Pushing Top N filter to DirectQuerysources  When using the TOPN function or a top N filter on a column from a DirectQuery source all valuesofthe column would be retrieved and then the top N filterwould be applied within the DAX engine. Here’s an example of a top N filter set using the filter pane: 6

  7. Reporting Unshared and unsynchronized axes for small multiples charts  When the ranges of the data for each small multiples category vary wildly, the charts with low maximums get pushed down compared to charts with high maximums. It becomes difficult to evaluate the sales trend for lower chartsbecause it looksclose to a horizontalline. 7

  8. Reporting Slicer type formatting moved to Format Pane  Previously, to change a slicer’stype, forexample changing from relative date to a slider, these settings were only available in the visual header and only on hover. In addition, to change a slicerto “horizontal” required usersto first choose “list” from the visual header to see the option in the format pane andthen use the format paneto swap the orientation.  Now, these settings live in 1 place in the format pane making it easier to discover and change between slicer types consistently. Note, horizontal has now been renamedto “tile” basedon user feedback. 8

  9. Reporting Slicer type formatting moved to Format Pane  Another added benefit with this change is the new mobile formatting options now have accessto this settingtoo! Users can quickly update theirmobile layout slicersto use tileto be more mobilefriendly. 9

  10. Modeling DAX formula bar support for Desktop model view The DAX formula bar is now supported in Desktop model view. You can now create and edit measures, calculated columns, and calculated tables in the model view on Desktop. • 10

  11. Modeling New DAX function: EVALUATEANDLOG  It takes any DAX expression, evaluates it and returns the result. But that’s not all: it also logs the result, hence the name EVALUATEANDLOG, to the DAX evaluationlogthatyoucan read out using toolslike SQL Profiler. Making it easier to do comparison calculations This month we are introducing multiple new functions for DAX, targeted at making it easier to do comparison calculations in Power BI. The new functions we are introducing are : INDEX, OFFSET and WINDOW: INDEX retrieves a result using absolute positioning. OFFSET retrieves a result using relative positioning. WINDOW retrieves a slice of results using absolute or relative positioning. 11

  12. Choose Anantara Solutions  Anantararepresentsthe most progressive thinkingon:  1.Partnering with clients  2.High valueconsulting-drivenBusinessSolutions  3.Exploiting emerging and established Information Technologies to create businessValue  Think of us as a next generation outsourcing company. Or as a next generation consultingcompany. Reach us  https://www.anantsol.com https://www.linkedin.com/company/anantara-solutions/ 12

More Related