Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I’m trying to create a visual that resembles the following table:
Category 1 | Category 2 | Category 3 | Jan-24 | Feb-24 | Mar-24 |
A2 | B2 | C2 | 33 | 11 | 4 |
A3 | B3 | C3 | 44 | 22 | 111 |
A4 | B4 | C4 | 5 | 6 | 7 |
I want users to dynamically select which columns for Category 1, Category 2, etc., should be displayed. I've achieved this using a parameter table. However, when users make selections from the slicer, the categories appear in a hierarchy within the matrix visual. My goal is to have them displayed as individual columns instead.
Any suggestions on how to achieve this column-by-column view? Thank you!
Solved! Go to Solution.
Hi @asparagus1_
Have you the tabular view in the matrix with repeat headers on.
This puts them in seperate columns.
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Hi @asparagus1_,
Take a look at this gif:
I'm attaching a pbix file with this solution.
Proud to be a Super User!
Hi @asparagus1_,
Take a look at this gif:
I'm attaching a pbix file with this solution.
Proud to be a Super User!
Thank you!
Hi @asparagus1_
Have you the tabular view in the matrix with repeat headers on.
This puts them in seperate columns.
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Thank you!
User | Count |
---|---|
75 | |
75 | |
45 | |
31 | |
27 |
User | Count |
---|---|
99 | |
89 | |
52 | |
48 | |
46 |