cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
UK_User123456 Resolver I
Resolver I

Filtering

Hi All,

 

I have 3 line & stacked column charts, the 1st is a Year over year, the second is a month over month and the 3rd is a day by day performance graph, is there a way of being able to have a filter so that when a user clicks a year, the months graph would reflect the year selected and then the day to reflect the month depending on what month was selected for that year? I have tried editing the user interaction, but this doesnt seem to work and was wondering if there was another way around it?

 

TIA

2 REPLIES 2
Super User III
Super User III

Re: Filtering

Hi @UK_User123456,

 

how does your model look like? Are your 3 visuals pulling data from the same table? If yes, then filtering on year should filter all 3 visuals. How are your month values formatted? Are they date values, or have you created texts like 'Jan-2020'? There is quite a lot that could impact how your visuals filters, and it would be much easier to help you if you posted you report or a relevant sample report(don't post confidential or sensitive information)(upload to e.g. oneDrive and share the link).

 

Cheers,
Sturla

UK_User123456 Resolver I
Resolver I

Re: Filtering

@sturlaws yes the 3 tables are pulling in from the same data table. The filtering does work initially, however selecting the year works as the months and day graphs filter correctly, but when the user selects the month from the months graph the year graph then reverts back to non selected. I have disabled non filtering when selecting the months graph so that the year graph doesnt change when selecting a specific month but this doesnt work.

 

My year graph is a date value, my months graph is a text value due to only showing the month, my day graph is a date value.

 

I will try and upload a sample.

 

TIA

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors