Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.