Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everybody. I'm very new to Power BI, with no background whatsoever on software like this (I've onlye used Excel my whole life), so excuse me in advance if it takes a while for me to understand... I promise to make an effort!
I sell products. So I wanted to see how many units of certain products I have sold each month and to which client, so I built a matrix controlled by a "Products" slicer (top left corner of the picture), where the row header shows "Clients", and the column header shows "Month", so in the Slicer I can select product "A" and in the Matrix I see in the first column (row header) all the clients that have bought product "A", and in the columns I can see how many units they have bought each month . I also have this same data showing in a graph (the one on the picture). This is working fine.
Now, I need to display the same data but instead of showing "Clients" as the row header, I want to see "Products", so I can easely see how many units I've sold for each product, each month. But I don't want to have to build a whole other Matrix and Graph, it doesn't fit in this report page, so I want to be able to have a slicer (I guess) where I can choose to see this data either by "Clients" or by "Products".
Is there any way I could do this? I would really really appreciate your help!
Thanks Power BI community!!
Solved! Go to Solution.
Hi @Anonymous ,
look at this.
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Hi @Anonymous ,
look at this.
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |