Forum Discussion
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 created in Tableau), if they selected 'Feb-21' from the 'Select Month' parameter drop down, the bottom 4 graphs will show that month and the 2 months prior. If they selected Jan-21 then: Jan-21, Dec 2020 and Nov 2020 would appear in the graphs below and so on.
The thing is that i want the bottom 4 graphs to populate that way but i want the top graph to not change. 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.
In Tableau, i created a 'Select month' parameter and then wrote a calculation and included that in the filter. The calculation was 'DATEDIFF('month', [Month], [Select Month]) < 3 AND DATEDIFF('month', [Month], [Select Month]) >= 0'.
I am struggling to replicate this calc and parameter in PowerBI (our company has moved from Tableau to BI). Can anyone help please?
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.
4 Replies
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 , You select one date/month and want to show more in trend. You need an Independent table
refer to my Video: https://www.youtube.com/watch?v=lOEW-YUrAbE
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!
