Forum Discussion
Dynamic Formatting of Measure
Hi Folks,
I have a report containing a table that allows the user to select the metric they are viewing for the report:
The idea is to condense report layout and reduce the number of fields on a report page.
It works quite well, but because the selected metric could be £, %, M^2, etc the measure is set to 'General' format.
Is it possible to change the format of the measure based on the selection? Or to somehow append/prepend the appropiate unit symnbol?
I thought of concatentating with a string but that stopped it being treated as number.
I might just be onto a loser but any suggestions would be greatly appreciated!
Thanks in advance 🙂
Either use calculation groups with custom formatting, or make that measure a text.
4 Replies
Either use calculation groups with custom formatting, or make that measure a text.
Thanks for the tip - I'll do some reading on calculation groups 🙂
For anyone else who finds this the following is a starting point for calculation groups: https://www.youtube.com/watch?v=XCugcQ-_Zfk
This page was also helpful: https://www.sqlbi.com/articles/controlling-format-strings-in-calculation-groups/
And the free version of Tabular editor can be found here: https://github.com/TabularEditor/TabularEditor/releases/tag/2.16.5
Caluclated Groups are not working for dual axis,Is there any other solution availble to format a measure dynamically?
