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.
In 2021 showing thousands or millions etc is now just a format option on the Matrix. The accepted solution involving making measures is now obsolete. Is there a way to flag out of date questions and answers?
I cannot find the option to format values as thousands in a Matrix. Can someone post a screenshot of where that is?
- calerof
Impactful Individual
Hi PeteD ,
Not closed for me. If we're using a matrix to show a series of measures and improve performance, instead of using multiple single card visuals, then the measures appear without rounding. If we fix a rounding to display units in millions for example, then when we change the period from YTD to MTD the value may not reflect a useful amount, just $0.0M. This feature to change automatically doesn't exist, correct?
Regards,
Fernando
nilimarodriguesHelper III
Agreed. The visual could show the data based on any value selected for a slicer. For eg. WW will have numbers in millions but looking at specific region/country through same visual, screws up the data labels.
