Matrix with Dynamically changing rows based on slicer selection

[Mahendran_C_S]

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.

[Anonymous]

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.

[Anonymous]

@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.

Dynamically select measures to be shown on a Power BI visual via slicer | Excel Inside (excel-inside...

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Mahendran_C_S]

@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?

[amitchandak]

@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

[Mahendran_C_S]

@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.