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.
Hi,
I have a matrix that can be drilled down on products and the products can be further drilled down to relations. So i can see a product per relation.
Now i want to change the order, so first see a relation and drill it down to which products it bought.
Off course i can copy the matrix and change the hierarchy in drilling, but is there a way to do this in the same matrix?
In other words i just want to have a sort of changable view in the matrix.
Thanks!
Solved! Go to Solution.
It is not possible to do this in the same matrix.
but if you dont want 2 visuals in you report maby a bookmark can work.
make 2 different matrix an put then on top of each other.
make 1 bookmark with matix 1 visable en matrix 2 disabled.
and an other bookmark with the opist, matrix 1 disabled and matrix 2 visable.
as last make a toggle feel picture. like a on and off button. https://www.youtube.com/watch?v=_Afcj8mT5_Q
user can then switch to which matrix they want to see. everything else look the same also filters only a different visual.
can this help?
It is not possible to do this in the same matrix.
but if you dont want 2 visuals in you report maby a bookmark can work.
make 2 different matrix an put then on top of each other.
make 1 bookmark with matix 1 visable en matrix 2 disabled.
and an other bookmark with the opist, matrix 1 disabled and matrix 2 visable.
as last make a toggle feel picture. like a on and off button. https://www.youtube.com/watch?v=_Afcj8mT5_Q
user can then switch to which matrix they want to see. everything else look the same also filters only a different visual.
can this help?
Works perfectly, had some trouble finding where to hide the visuals.
It's under; view - selection pane.
Many thanks!
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |