Forum Discussion
akos_skutovics
Helper I
Helper IDAX Date Range Summary
Does anyone have effective DAX code for summarizing a selected date range in an easily readable format for both continuous and non-continuous periods? I typically use a slicer with these columns: ...
lbendlin
Super User
Super UserWhat 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_skutovicsHelper I
Helper II 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?
- akos_skutovics
because filter pane is not dynamically filtered, and slicers are faster. not to mention multi-level slicers.