Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear colleagues,
After flicking through several post on this matter, I found no suitable solution to my problem and so I'm turning to you for expert advice. The posts I consulted are:
Solved: How to have dynamic date filter on Columns (NOT ro... - Microsoft Power BI Community
Solved: Can a slicer filter only rows on a matrix chart an... - Microsoft Power BI Community
Slicer to not filter rows in matrix. Want all rows... - Microsoft Power BI Community
Problem statement: I have a matrix visual which is acting as a pivot table. On the rows, I have the different clusters I want to keep visible all the time. On the columns, however, I want the slicer to filter them. Moreover, the values should be affected by the slicer too.
My table has the following structure:
Row header | Column 1 | Column 2 |
Skill_A_Department_B_Segment_C | Value % | Value % |
Skill_B_Department_A_Segment_C | Value % | Value % |
The slicer (empoyee ID) should only filter the columns and their values, leaving all the rows visible all the time even if the person cannot be classified as Skill_B_Department_A_Segment_C so to say .
Regarding the data sources, both columns and rows come from the same table. Only values are being retrieved from a different data source but both are linked.
Is there any way to achieve that?
Thank you so much,
Solved! Go to Solution.
@Álvaro_SM , Based on what I got so far, you need independent table/s to make it work
Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE
If this does not help
Can you share sample data and sample output in table format?
Thanks a lot @amitchandak , in the end it'll be cleaner if I transform the data back to wide format via data transformation. Anyhow , the video is a great resource!
@Álvaro_SM , Based on what I got so far, you need independent table/s to make it work
Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE
If this does not help
Can you share sample data and sample output in table format?
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |