Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Is there a way within a matrix visual to display all columns for 1 value but only 1 column for a 2nd value?
I thought I found a work around by shrinking the columns I dont want to see to be not existent. That works but when the data refreshes each week it reformats the columns and no longer displays as I need it to. It behaves that it holds on to the format of the specific column, not the column number as excel would.
If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.powerbi.com
| User | Count |
|---|---|
| 15 | |
| 14 | |
| 12 | |
| 11 | |
| 8 |
| User | Count |
|---|---|
| 40 | |
| 38 | |
| 29 | |
| 28 | |
| 22 |