Forum Discussion
Helper IDAX Date Range Summary
Super UserSounds like a nice project. There will be lots of pitfalls (for example when someone selects 2024 Q1 and September 2023) but it will be fun to explore all the intricacies of ISINSCOPE. Good luck.
Note: Is that something that your users asked for? What is the business value? Why not use the filter icons?
Helper IWhen 2024 Q1 and September 2023 are selected, I would probably default back to month level:
Sep 2023, Jan-Mar 2024.
The use case is to display a summary of what is shown on a page in combination with other slicers and description of the main visuals, for easy understandability for people who does not have a lot of experience with consuming Power BI content.
What would be the most optimal way to tackle this?
- lbendlin
What would be the most optimal way to tackle this?The most optimal way would be to not do it. Instead, educate your users about the visual filter icon.
- akos_skutovics
I understand your point, but I have to disagree with this perspective. If a user wants to gain insights more quickly and efficiently, I don't think it's fair to respond with, "you just need to improve and think faster."
Not to mention other scenarios when the insights need to be shared with others, or for pages with several dropdown slicers.
- lbendlin
yes, we can agree to disagree.
or for pages with several dropdown slicers.This, so much this. Why waste screen real estate with slicers when you could use the filter pane?
- MFelix
There is also this video with this solution from Alberto Ferrari:
