dynamic measure format
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
Very important from my point of view. Highly requested by our customer.
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.
Blair Clarkson commented
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.
This would be valuable for KPI formatting.