Forum Discussion
Matrix with Dynamically changing rows based on slicer selection
Hi everyone,
I have a requirement to display values in a matrix visual where the selection of rows and columns should be done by the user. Those rows and columns are displayed separately in a slicer visual for user selection. For me, columns are displaying dynamically when required columns are selected in the slicer. But I couldn't able to display rows dynamically in a matrix based on the user selection. Can anyone suggest to me any ideas to achieve that requirement?
Here are my report screenshots:
Below one is a selection visual displaying columns/measures to be selected by the user.
My current matrix with dynamically selected rows:
Rows selection visual consists of these columns/dimensions:
| Row Selection |
| Country |
| City |
| Store name |
| Product |
If the user selects one or more rows from the selection. The matrix should dynamically change its rows according to the selection made and the hierarchy must be in the order of order which is selected in the selection visual.
I would be grateful if anyone suggests to me any ideas to solve the above-said requirement.
Thanks in advance.
5 Replies
Mahendran_C_S , if Country, city are row values then you can have dynamically change axis/row/columns of a matrix.
Or you need to use bookmarks
amitchandak I couldn't get you. Can you share a reference link or tutorial for the solution you are mentioning? I am looking for a selection-based solution rather than using bookmarks. Because I have multiple columns/dimensions for that selection.
Mahendran_C_S
You need create multiple measures to replace the columns, using if(Contains()) function. Follow the tutorial below, the example is a chart but also works for table and matrix.Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.Anonymous My requirement is to select rows like country name, project name, and store name, etc., But the above refers to only measures which will be displayed if the selection occurs. Is it possible to achieve dynamic row selection for a matrix with a drill-down option in the selected order in power bi?
Hi Mahendran_C_S !
By any chance did you manage to do it? I have to do the same, but I'm not able to do it for now.
