Forum Discussion
How to make filters more apparent?
I have a business request where I am required to make my filters which are applied should be apparent, in other should be more obvious which filters are applied. I know we can view it by hovering on the filters button on the visual. But need something more obvious.
Like, "Showing results for timeline 18/03/2024 to 25/03/2024".
Moreover, is there a way to make a "week" column where I can put weeks from monday-to-sunday, and in a date-to-date format.
What I mean is showing past weeks as "29/04/2024(Sunday) to 05/05/2024(Monday)".
(Currently, I have made a date Offset and divided the daycount by 7 to make weeks offset)
DAX measures for refrence:
Thanks!
Got the solution for my second query.
DAX:
Week = FORMAT('Calendar'[Date] - WEEKDAY('Calendar'[Date],2) + 1,"d/m") & " to " & FORMAT('Calendar'[Date] - WEEKDAY('Calendar'[Date],2) + 7,"d/m")
3 Replies
- DataNinja777
Super User
This works! Thanks.
If you have a solution for my second query as well then I will accept as solution.
Got the solution for my second query.
DAX:
Week = FORMAT('Calendar'[Date] - WEEKDAY('Calendar'[Date],2) + 1,"d/m") & " to " & FORMAT('Calendar'[Date] - WEEKDAY('Calendar'[Date],2) + 7,"d/m")