Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi there,
I have a table in my dashboard and within the table, there is a status column. The status displayed are: in progress, compleete and unassigned. Is there a way to color code these status so in the status column, the status will look like below with different colors(now the text color are all in black)?
In progress
Complete
Unassigned
Thank you very much in advance!
Best,
Emily
Solved! Go to Solution.
Take a look at this article: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
and you'll want to use the Font Colour Option from the format visual > Cell Elements section.
Hi, Yes it's possible using Conditional Formating and a measure to do it.
Watch this video: https://www.youtube.com/watch?v=HYhVSltxSuY
The same method applies to table visualisation
Proud to be a Super User!
Take a look at this article: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
and you'll want to use the Font Colour Option from the format visual > Cell Elements section.
Thank you so much! I was able to make the changes!
select the cell elements selecting the column on your visual settings
use this column to do conditional formatting, you can set in there use a field value rule witt a measure
so on your visuals setting
and create one line per your required output
Proud to be a Super User!
Thank you so much @vanessafvg! I used the method shared a bit earlier but thank you very much for your tips
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
108 | |
101 | |
92 | |
69 |
User | Count |
---|---|
172 | |
135 | |
132 | |
101 | |
95 |