Dynamically Changing Measures shown on Rows of matrix visualization based on selection from slicer

[mnr461]

Hi,

i am a bit new to Power BI,

I have a scenario in which i have to select a value from a list values.

Based on Selected value from slicer Matrix value should show the values for several measures.

Ex:

Slicer:

• Branch Activity
• Branch Performance

If I select Branch Activity, Matrix visulaization should show Number of accounts and AMB measures on rows of matrix.

If i select Branch Performance matrix visualization should show No of Insurance Policies, No of Employees measures on rows of matrix.

In short, i need to change the measures on rows of matrix visualization dynamically based on slicer selection.

Is there any way to achieve this?

Any help would be appreciated.

[Seward12533]

Easy to do in Excel with Power Pivot but with Power BI Its hard to chang the rows of a matrix dynamically since you can't put measures there.   If your ok with flipping your table and having the columns dynamicall change you can use a disconnected slicer as a control for what is calucated in the measure.

Something like

Number = VAR Choice = SELECTEDVALUE(choicetabe[choices],"Activity") RETURN // returns choice or defaults to Activity
                                  SWITCH(TRUE(),
                                  "Activity", [Number of Accounts],
                                  "Performance", [Number of Policies])

But your probably better off with bookmarks and multiple visuals that get hidden or shown.

[mnr461]

Hi,

i am a bit new to Power BI,

I have a scenario in which i have to select a value from a list values.

Based on Selected value from slicer Matrix value should show the values for several measures.

Ex:

Slicer:

• Branch Activity
• Branch Performance

If I select Branch Activity, Matrix visulaization should show Number of accounts and AMB measures on rows of matrix.

If i select Branch Performance matrix visualization should show No of Insurance Policies, No of Employees measures on rows of matrix.

In short, i need to change the measures on rows of matrix visualization dynamically based on slicer selection.

Is there any way to achieve this?

Any help would be appreciated.

[Anonymous]

Hi @mnr461,

If there is a known number of options in the slicer, you can use buttons for each option and assign bookmarks to each, where in each bookmark the correct  matrix is shown and the rest is hidden.
Here is a link that explains the use of bookmarks:
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

Regards.

[v-juanli-msft]

Hi @mnr461

“change the measures on rows of matrix visualization dynamically based on slicer selection”

We can dynamically change the information based on a slicer, Blog here introduces how to achieve this.

However, as I tested, I can’t add any measure to the Row Field of a Matrix.

If you have any question to figure it out by yourself, please share some example data or pbix to let me know better about your data scheme and requirement.

Best Regards

Maggie