The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi There,
I have following Date Picker slicer coming from "Transaction_Date" column.
I want by default when user will open report it will show latest Transaction Date On both Start and End.... i.e. only 1 day date range and latest. For example, today it should show "14-JUN-2023" and both Start and End.... But they should have the option to alter/adjust start and end as per their choice.
How this could be done?
I understand, I can create a New derived column and over there I can calculate "latest date" and rest of days and then create a Dropdown Filter with default "Latest Date" selected while publishing etc.... but that one we can not use in Slider right.... I prefer to use a slider. Any option?
Thanks for your response @amitchandak
Still I am unclear how my concern could be addressed. As I mentioned...
"...I understand, I can create a New derived column and over there I can calculate "latest date" and rest of days and then create a Dropdown Filter with default "Latest Date" selected while publishing etc.... but that one we can not use in Slider right.... I prefer to use a slider. "
@RKM , Try if this approach can help
Latest
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0
User | Count |
---|---|
79 | |
74 | |
42 | |
30 | |
28 |
User | Count |
---|---|
108 | |
96 | |
53 | |
48 | |
47 |