#PowerJanta – Power BI March 2021 Feature Summary

Power BI

Microsoft launched its Power BI March 2021 Feature Summary last week. Here is my selection of noteworthy highlights in Power BI Desktop.


  • DirectQuery for PBI datasets and Azure Analysis Services
    • Noteworthy changes here since Dec 2020, you can now connect to PBI dataset from DQ.
    • We can now do Chaining of PBI Datasets, essentially using multiple PBI datasets in one report.
  • New Selection Controls in Azure Maps Visual


  • X-axis constant line for line charts
    • Something that was needed for a long time


  • New icon for Limited Relationships
    • A Limited Relationship is a relation between 2 different data sources. We can now identify it directly via the icon
  • Error Icon Tooltips
    • If you create a measure with an error and save it. It will now show a tooltip displaying that error with a red triangle icon next to that measure.


    • This is like a more optimized version of IF, it is useful when you have a measure in the condition as well expression part. Check the example below.
    • Here [Total Sales] or [Last Month Sales] will be evaluated 2 or 3 times, once in the condition and then again in the TorF expression.
    • EAGER avoids these evaluations thus enhancing the performance. But, MS recommends that one should not simply use this instead of IF unless one has a specific requirement or performance issues.
Sales = IF ( [Total Sales] > [Last Month Sales], [Total Sales], [Last Month Sales]-[Total Sales] )
    • This is something that we all have been waiting for.
    • Remember the time when you wanted a sum based on two filters and thought of using CALCULATE but ended up writing a lot more using FILTER() and ALL()
    • Now you can simply do it using CALCULATE. Whether this change will affect the DAX lineage in any is something we will have to wait and watch.

Old Way:

FilteredSales =
          Sales[Sales Amount],
             ALL( 'Product'[Color], 'Product'[Style]),
             'Product'[Color]="Red" ||

New Way:

FilteredSales =
          Sales[Sales Amount],
          Product[Color] = "Red" ||
          Product[Style] = "W"


If you like this content or want me to stress on something, feel free to reach out to me at me@saurabha.com with your comments, suggestions and feedback.

Check out my previous post titled #PowerJanta – Power BI February 2021 Feature Summary. To know more about #PowerJantaclick here.

Image Credits: Microsoft’s Official Power BI March 2021 Feature Summary.



♥ Subscribe to our newsletter

Love our content? Subscribe now to get notified when we publish new articles.

Fill out this field
Please enter a valid email address.

Read More Articles 👇🏼