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.
Hi I tried both. This normally works and I have formatted hundereds of time over the years. It just seems to be with this particular pbix file lmost like its corrupted. I just opened up a new pbix and connected to the same table nd it works fine. I was hoing to avoid building a report again 🫠
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 ...