dynamic update of visuals for multiple columns

[Anonymous]

Hi,

i am trying to create the matrix visual whose values should get changes as per column selection.

i have metrics of countries and brand as matrix column and header. values in the matrix appear as per column selection but i need to create multiple matrix visuals to see each column data in matrix view.

i want some filter or slices which can make this matrix visual dynamic.

[v-juanli-msft]

Hi @Anonymous 

Would you like the matrix to show value for many columns when selecting many selections from a slicer?

If so, add the column used in the slicer to the "column" field of the matrix,

when you select many values from sclier, click the icon to expand all levels of the matrix column.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi v-juanli-msft,

Thanks for your response. 

Actually i want the data to update in the matrix visual as per column selection (one at a time). i do not need to have data for multiple column together.

All i need is instead of creating 10 matrix visual per column , i can create 1 which can get updates on column selection.

see snap shot i tried creating to showcase my requirement.

the checkboxes in the right are columns and have values in Green,pending,red and n/a. i need i can get this metrix updated as per columns when i select them but i do not konw how can i map multiple column values with matrix view

[v-juanli-msft]

Hi @Anonymous 

In addition, there are other useful methods which may be helpful.

https://community.powerbi.com/t5/Desktop/Select-columns-in-table-dynamically-based-on-Slicer/td-p/411580

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Would you like this result?

Assume your data as below

If so, please unpivot the 10 columns in Edit queries,

Then rename the column "Attribute" as "selection", close&&apply.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.