How to make filters more apparent?

[ash757]

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:

DayOffset = ABS(DATEDIFF(TODAY(),'Calendar'[Date],DAY))

Last N Weeks = CEILING(('Calendar'[DayOffset]/7),1)

Thanks!

[DataNinja777 · Accepted solution]

Hi @ash757 

Does the below meet your requirement?  

I attach an example pbix file.  

[DataNinja777 · Accepted solution]

Hi @ash757 

Does the below meet your requirement?  

I attach an example pbix file.  

[ash757]

This works! Thanks. 

If you have a solution for my second query as well then I will accept as solution. 

[ash757 · Accepted 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")