Dynamic Formatting of Measure

[robadob]

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 🙂

[Ramgopal_PBI]

Caluclated Groups are not working for dual axis,Is there any other solution availble to format a measure dynamically? 

[robadob]

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 

[lbendlin · Accepted solution]

Either use calculation groups with custom formatting, or make that measure a text.

[robadob]

Thanks for the tip - I'll do some reading on calculation groups 🙂