Unable to format Text

[cottrera]

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 the final touches the format page looks like this. The 'What field should we base this on' field is highlighted red and will not letme choose a field to format

Any thoughts

Richard

[cottrera]

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

[SamWiseOwl]

Is the field a measure or a column?

[cottrera]

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 🫠

[SamWiseOwl · Accepted solution]

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.

[cottrera]

😁Well done for your persistnace and saving me lots of time 👊

[SamWiseOwl]

I just wish I knew why it was broken in the first place ...

[SamWiseOwl]

Hi @cottrera 

Does the column hold a number?
If so you could either format the column to be text or create a new column/measure and format that to be text.