How to preselect the checkbox of week number in PowerBI?

[deb_power123]

Hi All,

Is there any available settings or way to handle preselection of the checkboxes in PowerBI?

I want the latest WeekNumbers to be always preselected in my visualization. Weeknumber should correspond to the system date.

Is there a way to achieve this ,may be using DAX?

The one pointed in blue arrow represents the latest 3 week numbers which I want to be preselected should always correspond to the system time. We are at present in week number 20 so the latest three weeknumber is Week17,Week18 and Week 20 so these three values should be preselected in the filter of the visualization.

Is it possible ? if so then how?

(I have used this DAX to calculate the weeknumber)

WeekNumber = WEEKNUM([Date]),21)

Expected output:

Input data :

Date	Location	%attendance
01.12.2020	B1	70
01.12.2020	B1	20
01.12.2020	B1	61
02.12.2020	B2	30
01.05.2021	B3	29
01.05.2021	B3	80
03.05.2021	B3	22
04.05.2021	B4	20
18.05.2021	B5	61
19.05.2021	B1	30
20.05.2021	B2	29
21.05.2021	B3	80
22.05.2021	B4	54
23.05.2021	B4	38

Kind regards

Sameer

[sanman · Accepted solution]

Create a new column called weekType and use dax to set that column to "Latest Week" if the date is from latest week. If not set it to "Prior Weeks".

Add Custom Column: WeekType = if Date.IsInPreviousWeek([Date]) then "Latest Week" else "Prior Weeks"

Then you can use the slicer with WeekType and Date heirerchy with the Latest Week checkbox selected.

Hope it works out!

[Fowmy]

@deb_power123 

This is not possible yet. if you want to filter any visual with relative date, you can use the filter pane to set it as follows

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range