Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
This article has several version of Date tables that all include a column called WeeksFromNow that you could use to filter any of your visuals where WeeksFromNow <=0 and WeeksFromNow>= -3.
No Sort Date Tables! – Hoosier BI
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
42 | |
39 | |
19 | |
19 |