Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys!
Need your assistance on my project.
Currently, we're migrating from one visualization to Power BI.
The visualization has below filter date range:
When we click the Between option, calendar option will be displayed.
How can we do this in Power BI?
We assume to use 2 slicers like below:
So if the user wants to use the Last/Next/This option, he will use the first slicer and changes will take effect to all visualizations in the page. The 2 slicer (between) should be disabled and vice versa. Is this possible?
Please advise.
@v-eqin-msft @Tahreem24 @amitchandak @Greg_Deckler
Solved! Go to Solution.
Hi @gilbertendaya ,
Try to refer to my .pbix file.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
So if the user wants to use the Last/Next/This option, he will use the first slicer and changes will take effect to all visualizations in the page. The 2 slicer (between) should be disabled and vice versa. Is this possible?
@gilbertendaya , If you want enable only one Date slicer option at a time so use the combination of Button and Bookmark features. If you want to visit the link in my singature there is one Toggling option between Tabular View and Graphical View so you can also make something like that.
hi @Tahreem24 thank you for the feedback. I saw the button and bookmark feature and it seems it can only reset the page. Is there a way to enable or disable slicer? Can you provide me a sample on how to do this?
thank you for the support.
Hi @gilbertendaya ,
Try to refer to my .pbix file.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@gilbertendaya , In power bi You have relative date slicer
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Date Slicer you can change to between, before, or after slicer.
I think what you are looking for, you might have to build something like : https://community.powerbi.com/t5/Desktop/Required-custom-date-Slicer-Last-7-days-last-15-days-last-3...
@amitchandak thank you for the reply.
I saw the relative date for slicer but I'm afraid this is not available to change once we deploy the dashboard to Power BI service.
That's why I'm planning to use 2 slicers hmm
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |