Blog

Read informative blogs-curated by our experts.

Learn more about Microsoft SharePoint, Power Platform. Dynamics 365 and other services, and how they can boost productivity and efficiency at your organization.

    Archives

    Link Categories

    Power BI Desktop Updates

    Power BI Desktop July 2020 updates

    For all the nerds out there, Microsoft has some exciting news. There have been several new updates in Power BI Desktop. Check out this blog and find out updates in the Reporting, Analytics, Visualization and Modelling section.

    Reporting

    1. Legends – Now you can include legends for data colors that have been conditionally formatted by color scale. This legend can help clarify the data range that the color represents. You can find the conditional formatting dialogue in the Data colors card of the formatting pane.
    2. Ability to customize the slicer header text – With the release of general availability of hierarchical slicer, this month there is a release of the ability to further customize the slicer header text. 
    3. General availability of Relative time filter – relative time filter was released in April which allows the user to filter to a smaller window of time, such as last 1 hour or last 1 minute. This month it has been made generally available.

    Analytics

    1. New field synonyms: Now you can manage the synonyms for tables and fields and include or exclude specific tables and fields from Q&A. Turning off ‘Include in Q&A’ for a table will hide everything in that table from Q&A and on expanding a table, you’ll see the table name and all the fields with their terms and suggested terms. 
    2. Visual renames as suggested synonyms: With this new update field renames has been added from visuals in the report to the list of suggested terms. With this feature, you can change a field name on the axis of a line chart. 
    3. Orange underlines for ambiguous terms: Along with red double underlines and blue underlines, the third type of underline has been added to the Q&A question box – an orange dotted underlines for ambiguous terms. The new underline helps distinguish this ambiguity so you can adjust your question if needed.
    4. Updates to Q&A pop-out: Now you can see the pop-out aligns with the Q&A visual experience. It also contains any suggested questions you have defined in Q&A setup.

    Visualizations

    1. Bubble layer: Now represent location data as scaled circles on a map. Users can pass a value into the legend field and have the fill colour of the circles dynamically set; also outline the circles with a single color or enable the high contrast outline option to help ensure the circles are visible regardless of which style the map is set.
    2. 3D bar chart layer: 3D bar charts allow visualization of location data as 3D bars or cylinders on the map. 3D bar chart layer can easily visualize two metrics at the same time using colour and relative height.
    3. Reference layer: With this update, you will be able to overlay additional data layers to add more context to a report. A GeoJSON file containing custom location data can be uploaded and overlaid on the map moreover, its properties can be used to customize the style of the shapes.
    4. Real-time traffic overlay: Overlay real-time traffic flow data to see how traffic congestion relates to your data. Real-time traffic is overlaid on the map and provides a quick visual reference of which technicians are most likely to be delayed getting to their next job due to traffic congestion.

    Modelling

    For financial professionals, there has been an addition of 49 financial functions to DAX to support Excel’s built-in financial functions. Together, these new financial functions make it easier to build financial reports and perform otherwise complex calculations in Power BI. 

    Tell us in the comments section how you feel about these recent updates. Follow Evolvous Limited on LinkedIn and keep receiving similar interesting and informative updates! Or contact us here: https://evolvous.com/contact-us/ 

    Leave a comment

    Your email address will not be published. Required fields are marked *