Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Want to create a table/list like the one under. Anyone with some sugestment on how to give it a color and the precentage?
Solved! Go to Solution.
Hi @mathician
You can select the table or matrix, go the the visualizations pane.
Here, you will see "Conditional formatting".
Expand this, and select the column you desire. Turn on "Icons".
Select Rules and assign number such as 1 the true value icon, and 0 the false value icon.
I believe you can also refer to this one:
For the percentage, you can add a measure or just show the data percentage of grand total.
Hi @mathician
You can select the table or matrix, go the the visualizations pane.
Here, you will see "Conditional formatting".
Expand this, and select the column you desire. Turn on "Icons".
Select Rules and assign number such as 1 the true value icon, and 0 the false value icon.
I believe you can also refer to this one:
For the percentage, you can add a measure or just show the data percentage of grand total.
@mathician Well, you could use concatenate and unicode characters or you could just use a new column that has the icons.
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
So just add your percentage twice, one with the conditional formatting
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.