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.
Thanks for the quick response SamWiseOwn I tried this route before posting on the forum. Again the issue is that
this field will not let me make any selections. I have never experienced this before.
Richard
Is the field a measure or a column?
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 👊