Conditional filtering between charts

[Anonymous]

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 get the sum value.

I would like to use the first diagram as a filter. When I dont use it as filter, then on the pie chart i would like to see the last yearmonth value, when i use on the first graph filter for example 202104, then i would like to see on the pie chart the 202104 value.

Is it possible?

Thank you in advance!

best regards,

bálint

[Anonymous · Accepted solution]

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]

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]

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

[amitchandak]

@Anonymous ,

you can use use isfiltered

if(isfiltered (Table[Year]), [Measure],calculate([Measure], filter(Table, Table[year month] =max(Table[year month]) ))

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/