Forum Discussion
Advocate IShow values as whole thousands
Ahh for a matrix, got ya. For those i believe you'd have to write a measure that would convert the output for you.
Maybe something like:
Your Measure = ([Your Value] / 1000) & "K"
You could add rounding in here too.
Yes, quite a lot of visuals allow you to do that. Look under the "Format" section of the Visualisation Settings. In there will be sections relating to the various displays. What you are looking for is an option called "Display Units" and "Decimal Precision". These are typically defaulted to "Auto", but you can set it to "Thousands" and 0
Advocate IYes i found that in other visuals however i cannot find it in the new Preview Matix visual (the one with drill down functionality).
I guess it's not an option in that.
Ahh for a matrix, got ya. For those i believe you'd have to write a measure that would convert the output for you.
Maybe something like:
Your Measure = ([Your Value] / 1000) & "K"
You could add rounding in here too.
- HenrikH29
Yes that was what i was "afraid of" .
I have a lot of values so i had hoped for a easier solution :-)
Perhaps it will come as an option later...
I just tested this on a file i'm working on thats fairly sizable. This was pretty fast:
Rev = VAR Result = round([Revenue] / 1000, 0) RETURN if( Result = 0, BLANK(), Result & "K" )
*Note [Revenue] is a measure i'm using that is a sum of data.
Answered my question Ross, didnt even need to send you an email :-)
