Forum Discussion

cmckinney's avatar
cmckinney
Helper IV
6 years ago

Clustered Column Chart Filtering a Matrix

What I want to do is when I click a certain row in a column chart it filters a matrix to only show the values that are related to it on a matrix.

 

In the following example I would like the matrix to only show Series Count and Series Elements when I click on the Series Bar chart. As of now when I click on the bar it wil filter by date. 

 

9 Replies

    • cmckinney's avatar
      cmckinney
      Helper IV
      6 years ago

      Anonymous 

       

      Thank you for your prompt reply. Unfortunately the video was unable to help me get my desired results. I had also tired editing the interactions before posting this thread. Do you know of any other possible solutions?

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        HI cmckinney 

         

        Can you click on the bar chat and paste a screenshot of how the interactions look like on the matrix.

        The interaction should be when left chart is selcted as below.

         

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support
        5 years ago

        Hi  cmckinney ,

         

        First create a date-dimension table:

        Table = VALUES(Test[Date])

        Then create 2 measures as below:

        _Category = CALCULATE(MAX('Test'[Category Element]),FILTER(ALL('Test'),'Test'[Date]=MAX('Table'[Date])))
        _Series = 
var _date=CALCULATE(MAX('Table'[Date]),FILTER('Table','Table'[Date]=SELECTEDVALUE(Test[Date])))
Return
 IF(SELECTEDVALUE(Test[Date])<>BLANK(),CALCULATE(MAX('Test'[Series Elements]),'Test'[Date]=_date))

        And you will see:

        For the related .pbix file,pls see attached.

         

        Best Regards,
        Kelly
        Did I answer your question? Mark my post as a solution!