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 moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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
User | Count |
---|---|
94 | |
92 | |
84 | |
83 | |
49 |
User | Count |
---|---|
150 | |
146 | |
112 | |
73 | |
56 |