This idea is currently "Started":
I've been needing this functionality for months now.
I had the same problem and this is what I did:
- Create a new column
- Create an IF formula based on your text column, make it take numbers instead of the values. For example, my text column contained "Yes" and "No". I used the formula New column = IF([Textcolumn]="Yes",1,0).
- Go to the Conditional formatting option and chose to conditional format based on another column, chose your newly created column.
- You can do this with the first two types of conditional formatting: by color scale and by rules.
As an alternative you can use a measure to retrieve the first value for conditional formatting instead of column aggregation.
First Value = FIRSTNONBLANK('Table'[Column 1],'Table'[Column 1])
Find your favorite faces from the community presenting at the Power Platform Community Conference!
See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.
Join this community-driven Power Platform digital event for unbiased support and problem-solving.