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.
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 January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
121 | |
79 | |
48 | |
38 | |
31 |
User | Count |
---|---|
192 | |
79 | |
70 | |
50 | |
42 |