I have a dimension with several KPI's in order to dynamically pass these KPI's to charts and other visuals. The problem is that some of this indicators/measures, are in currency format, others percentages, others number and I need a way to apply the format dynamically.... something similar to custom format of SSAS Cubes
9 Comments
- We can set the switch to use different text formatting for each result by wrapping each line with a FORMAT function That is a useful workaround, definitely not a full solution.
- my customers really want this. they are unhappy to see only 1 format for the $ amounts while they want different format. half of my users are unhappy.
- Very important from my point of view. Highly requested by our customer.
mstaceyAdvocate I
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- similar one https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32728060-dynamically-set-formatting-for-dynamic-measures
- Similar to https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17137087-dynamic-measure-format
- 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.
The workaround here is to create a dynamic measure using the SWITCH/FORMAT functions in DAX, but the major drawback to this solution is that the FORMAT function converts the values to text, so you can't can do any further calculations with the the output, nor can you properly sort the values in a grid in ascending/descending order. We really need a proper solution for this.
- Status added:Needs Votes
