Forum Discussion

vr_2020's avatar
vr_2020
Frequent Visitor
3 years ago
Solved

Matrix Chart

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 ...
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    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.

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

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.