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]
)

     

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

Oh that's amazing!! Thank you so much!!

One last question, I promise 😅

If I want to add in the rows of bar chart instead of the category the region and when no cell is selected in the matrix to display specific category and measure ( for example category 1 and measure 1) but when a cell is selected in the matrix (the matrix remains the same) to filter the bar chart based on the selected cell ( the corresponding category and measure)

I hope I am not asking for too much.

I want to thank you very much for your help. I really appreciate that 🙏 

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 😊