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.

ameera_williams's avatar
ameera_williams
Regular Visitor
5 years ago

amitchandak Thank you for your response. I watched your video and tried some of the steps, however i got lost as I am just a beginner in Power BI and i found it hard to translate the teachings in your video to what i am trying to do with dates and bar charts.

You mention at the end of your video that you will be doing a video specifically on dates soon? I will have to wait for that one.

It seemed a lot easier to do this in Tableau!