Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
142 | |
76 | |
63 | |
51 | |
47 |
User | Count |
---|---|
211 | |
82 | |
61 | |
61 | |
60 |