on 17 Nov 2016 03:05:01
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
- Comments (8)
- Merged Idea (1)
RE: dynamic measure format
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.
RE: 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.
RE: dynamic measure format
similar one
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32728060-dynamically-set-formatting-for-dynamic-measures
RE: dynamic measure format
Similar to https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17137087-dynamic-measure-format
RE: dynamic measure format
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
RE: dynamic measure format
Very important from my point of view. Highly requested by our customer.
RE: dynamic measure format
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.
RE: dynamic measure format
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.