Forum Discussion
Solved
Unable to format Text
Hi I am having an issue with the formatting option in power bi. Normally ifI wish to format a field based on Text I would use go here However I have just build a report and was about to add th...
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 ...