Matrix Chart

[vr_2020]

Hi - I am working on the following scenario:

Imagine the chart type in screenshot is Matrix Chart

1) When any , multiple or all values is selected in Slicer1, Matrix chart should display values in Col1, Col2 and Col3 as shown in the following screenshot

2) When I deselect any, multiple values or all values in Slicer1 dropdown, Matrix Chart should display the corresponding rows as Blank and with grey color background.

For example: When I deselect "Subcategory1.3" from Slicer1 dropdown, the corresponding row in Matrix chart should display as blank with grey color background and both Totals should get calculated as shown in this screenshot.

Any help is much appreciated.

[v-jianboli-msft · Accepted solution]

Hi @vr_2020 ,

Please try:

First create a new table for slicer:

For Slicer = SUMMARIZE('Table','Table'[Categories],'Table'[Subcategories])

Output:

Then apply the measure to the matrix visual:

Measure = 
SUMX('Table',IF([Subcategories] in SELECTCOLUMNS('For Slicer',"Sub",[Subcategories]),[Value],BLANK()))

Show items with on data:

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.