Forum Discussion

Dimitris_Kats's avatar
Dimitris_Kats
Icon for Helper V rankHelper V
2 years ago
Solved

Filter a bar chart based on selected matrix cell

Hi dear members. I need your help. I have a matrix with categories in the rows and multiple measures in the values. For example in the rows I have: Category 1 Category 2 Category 3 And in the ...
  • xifeng_L's avatar
    xifeng_L
    2 years ago

    Let's slightly modify the expression of the measure, pls try again.

     

     

     

    Use of Bar Chart = 
IF(COUNTROWS(ALLSELECTED(ColumnTable[Item]))>1,
    CALCULATE(
        [AutoIndicator],
        KEEPFILTERS('ColumnTable'[Item]="Measure1"),
        KEEPFILTERS('Fact'[Category]="Category1")
    ),
    [AutoIndicator]
)

     

xifeng_L's avatar
xifeng_L
Icon for Super User rankSuper User
2 years ago

Let's slightly modify the expression of the measure, pls try again.

 

 

 

Use of Bar Chart = 
IF(COUNTROWS(ALLSELECTED(ColumnTable[Item]))>1,
    CALCULATE(
        [AutoIndicator],
        KEEPFILTERS('ColumnTable'[Item]="Measure1"),
        KEEPFILTERS('Fact'[Category]="Category1")
    ),
    [AutoIndicator]
)

 

Dimitris_Kats's avatar
Dimitris_Kats
Icon for Helper V rankHelper V
2 years ago

This is amazing!!! It worked perfectly!!!

Thank you so so much 😊