Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Simple question, probably not a simple answer.
Say I have Sales by State, and a State Slicer.
I can set up a Bar Graph, select two states, get two bars. Select four states and I get four bars.
I want to build a matrix. I have Year and Month as rows, Sales as the value, and I want a column for each selected State. Select two states, get two Columns. Select four states and I get four columns.
I can Haz?
If it makes it easier, I will only be using this to present two states at any one time.
Phil
Solved! Go to Solution.
Hi @psmith-nhs-inc,
If I understand you correctly, it should be similar to how you set up a Bar Graph as you mentioned above. Just put the State column in the Column field of the Matrix, and also use the State column as Slicer on the report. Then you will get two columns on the Matrix, if you select two states.
And get four columns if you select four states.
Regards
Hi @psmith-nhs-inc,
If I understand you correctly, it should be similar to how you set up a Bar Graph as you mentioned above. Just put the State column in the Column field of the Matrix, and also use the State column as Slicer on the report. Then you will get two columns on the Matrix, if you select two states.
And get four columns if you select four states.
Regards
You are correct. A screwed up relationship was preventing the slicer from working properly. That does work as I need it to.
Thanx
Phil
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |