Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hello All,
I have a table in which i have data like min, max, null count etc. of all columns of around 45 tables(as shown below). Now i want to use a visual that shows null value count similar to a gauge visual with greater number of null value count in red, lower number of null value count moves toward green for all column names of all tables (Also every table has different column names, they are not
same for tables).
Hi @Anonymous ,
For the table that you attached, I think maybe you could try conditional formatting. It could change color and add icons to highlight the values. For more details, you could reference the documents below.
Conditional formatting in tables
Conditional Formatting Using Icons In Power BI
I tried to drag data into the visual that is like Gauge. It didn't work due to the columns that contains text and numbers. You could try conditional formatting firstly. If it is not what you want, please share a screenshot to show your expected result. Then we will understand clearly.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
| User | Count |
|---|---|
| 57 | |
| 44 | |
| 28 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 74 | |
| 63 | |
| 40 | |
| 23 | |
| 22 |