How to transform the display table

Hi harryli ,

You can accomplish this with a disconnected (no relationships to other tables) table that holds the values of the measures you want to display. The order column allows you to set a custom order.

Then use a switch statement to display the correct value.

displaycolumn = 
var selection = SELECTEDVALUE('Measures (2)'[Measure])
RETURN
SWITCH(
TRUE(),
Selection = "Total Bed", [Total Bed],
Selection = "OC", [OC],
Selection = "FR", [FR],
Selection = "NOP", [NOP])

Then create a table with the Measure column from the disconnected table and the displaycolumn measure.

I hope this solves your question - if it does please mark it as a solution!

Hi harryli ,

No, to follow the solution that Signore_Ands provided you just need to change your table to a matrix in the visualisation pane. Then the "Options" will be available to you.