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

Thank you so much xifeng_L  for your time and help. Is it possible to share with me the pbix file?? 

It's a little hard for me to follow your instructions based on the images.

Thank you very much 🙏 

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

    This is great. Thank you so much.

    I was wondering if it is possible when there isn't selected any cell to display only one measure instead of all measures??

    For example by default the bar chart to display measure 1 if no cell is selected.

    I hope this isn't a crazy request 🙈

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

      Sure, it can be achieve.

       

      You can create a new measure and use for bar chart. Pls refer to follow pic:

       

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

       

      Then, when you select any cells, it will display the corresponding indicators.

       

       

      Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

       

      Thank you~

       

      • 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 🙏