Skip to main content
Microsoft Idea

Power BI

Merged

Dynamically set formatting for dynamic measures

Vote (31) Share
Sanil's profile image

Sanil on 25 Dec 2017 14:59:19

Currently we can use same report to visualize multiple measures by adding new table with all the measure names and creating calculated measure using switch statement to display selected measure. However, if we want to display measure of different types for e.g. Currency/Percentage/Decimal, there is no option to set the format of measure dynamically. There should be option to set the format dynamically based on selected measure. This will avoid using separate reports for each graphs which can be handled using single graph.