Forum Discussion
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 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
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.
7 Replies
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.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.
RichardIs 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 ðŸ«
