Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
122 | |
109 | |
60 | |
55 |