Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditional filtering between charts

Hi Colleagues, I have an issue with filtering. So i have 2 graph, first  graph has YEARMONTH on the X line, the second is a Pie chart, which has not YEARMONTH dimension,therefore on the Pia chart i...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    Please refer to my pbix file to see if it helps you.

    Create measures and a column.

    measure_ = SELECTEDVALUE('Table'[date])
    Column = IF('Table'[Year]=MAX('Table'[Year]),'Table'[VALUE],BLANK())
    Measure_2 =
VAR _maxyear =
    MAX ( 'Table'[Year] )
VAR maxyaevalue =
    IF ( MAX ( 'Table'[Year] ) = _maxyear, MAX ( 'Table'[VALUE] ), 0 )
RETURN
    IF (
        MAX ( 'Table'[date] ) = [measure_],
        MAX ( 'Table'[VALUE] ),
        SUM ( 'Table'[Column] )
    )

     Then Click the bar chart>>Format>>Edit interactions. Then choose filter on pie chart.

     

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous , 

The interactions between bar charts and visuals don't work in the same way in between visuals. A bar chart can be  used to filter out information so when you click on a chart the information on other visuals  (including slicers) is filtered however when you click on a donut chart or pie chart the slicer is not filtered out, this as to do with the purpose of the slicer.

 

IfI have misunderstood your meaning, please provide your pbix file without privacy information and your desired output.

How to Get Your Question Answered Quickly 

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi,

 

Thank you for your answer.

 

Yes, i would like to use the bar chart as filter, the donut chart is not used for filtering.

 

So this is my goal, that the bar chart is not filtered, then we would like see in donut chart the max yearmonth volume, when the bar chart i choose for example the 202201, then the donut chart is filtered by bar chart.

 

I hope my question is clear 🙂

 

Thank you,

 

best regards,

bálint