Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |