Forum Discussion

ameera_williams's avatar
ameera_williams
Regular Visitor
5 years ago
Solved

Date Parameters/Filters

Hello, i would like to show data in my report for the month someone selects and the previous 2 months from that selected month. For example if you look at the screen shot below (which is what i creat...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi ameera_williams ,

     

     

    The thing is that i want the bottom 4 graphs to populate that way but i want the top graph to not change. 

     

    For this requirement, you can "Edit interactions" to make the visual unaffected by other visuals.

     

     

     

    Also, i only want the 'select month' drop down to have the date range: Jan-2020-March 2021, but the data set i have loaded into Power BI has data from 2019. I don't want users to be able to select anything before Jan 2020.

     

    You can set a visual level filter to filter the date from Jan 2020 to March 2021.

     

     

    Best Regards,

    Icey

     

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

Icey's avatar
Icey
Community Support
5 years ago

Hi ameera_williams ,

 

 

The thing is that i want the bottom 4 graphs to populate that way but i want the top graph to not change. 

 

For this requirement, you can "Edit interactions" to make the visual unaffected by other visuals.

 

 

 

Also, i only want the 'select month' drop down to have the date range: Jan-2020-March 2021, but the data set i have loaded into Power BI has data from 2019. I don't want users to be able to select anything before Jan 2020.

 

You can set a visual level filter to filter the date from Jan 2020 to March 2021.

 

 

Best Regards,

Icey

 

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