Skip to main content

Power BI

New

Dynamically set formatting for dynamic measures

Vote (23) 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.

Comments (2)
Sanil's profile image Profile Picture

2654cd36 a64d-47d7-81a4-11867fe8fc4d on 06 Jul 2020 00:18:23

RE: Dynamically set formatting for dynamic measures

Similar to https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17137087-dynamic-measure-format

Sanil's profile image Profile Picture

b59dc44e 2beb-4634-9268-0063d985295e on 05 Jul 2020 23:36:09

RE: Dynamically set formatting for dynamic measures

This could be gotten round by simply having a proper measure picker control!
I've done this in custom apps before and it would be super useful

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/36082540-measure-picker