Forum Discussion
Unable to format Text
Can you try creating a measure for me and using that for formatting.
Colour format =
Switch(
True()
,SelectedValue(table[Phase status]) = "Active", "Green",SelectedValue(table[Phase status]) = "Cancelled", "Red"
,"Blue"
)
To assign this change Format style in the top left from Rules to Field Value and then select this measure.
Can you try creating a measure for me and using that for formatting.
Colour format =
Switch(
True()
,SelectedValue(table[Phase status]) = "Active", "Green"
,SelectedValue(table[Phase status]) = "Cancelled", "Red"
,"Blue"
)
To assign this change Format style in the top left from Rules to Field Value and then select this measure.
😁Well done for your persistnace and saving me lots of time 👊
I just wish I knew why it was broken in the first place ...