Forum Discussion
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 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
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.
4 Replies
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/
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.
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
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.
