1 of 1 people found this helpful
There are some complex formatting options, but one of the easier ways is to make two calculated measures formatting them each the way you want. Then make the values 'null' for the dimensions with the wrong format.
I have an outline in this reply:
This doesn't work, Kris, as in my "Measure" column, some values are percentages and some values are just numbers. If I'll format the Measure as percentage, then it will show everything as percentage in the whole column.
Hi! I have the same scenario, as I'm working with KPI's and the raw data has some values as integers, decimals or percentage in the same column.
Category, KPI, Value
MRO, %AutoOrdering, 3.53 <-This is percentage
MRO, POCount, 400 <- This is an integer
MRO, POIC, 1 <- This is an integer
Is there a way to achieve this? I can create a different measure for each KPI, but I'm currently working with almost 20, so in the long run, I'll will be very difficult to mantain, so I'm looking for alternatives