Skip to main content
Microsoft Idea

Power BI

New

Allow use of report-level measures for conditional formatting

Vote (1) Share
Rasmus Ludvigsen's profile image

Rasmus Ludvigsen on 29 Feb 2024 13:51:03

In a nutshell:

As a Report Builder I would like be able to use report-level measures for conditional formatting, since this type of formatting is often very report specific and can clutter up a centralized model. Today report-level measures can't be used in conditional formatting.


Details:

When connected Live to an existing semantic model (aka datamodel) on SSAS or Power BI Service, a report builder - with no access to the central model - has the option to add report-level measures. This is beneficial, but to me a rather important use case for these measures seems to be missing. Report Builders often want to create dynamic titles, colors, icons, or complex conditional formatting via DAX measures to enhance the user experience. Today, conditional formatting in the "fx"-menu can't be based on report-level measures when choosing "Field value". The "Ok" button is greyed out. Only Report Builder with access to the actual model can utilise conditional formatting in full.


Two benefits, if implemented:

  • Empower Report Builders without access to the model, as they will get the full capabilities of conditional formatting and build better reports.
  • Avoid clutter in the model: The formatting-type measures are typically very customized for the report - and can clutter up a central data model that might service multiple reports.