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.
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 :-)
