Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Is there a way to have the value of a slicer to be the max date of the column that the slicer is built from? i.e. if the distinct values in the table are:
* 2024-03-01
* 2024-04-01
* 2024-05-01
* 2024-06-01
We would want the selected value = 2024-06-01. When the data for 2024-07-01 is loaded, I would want to default slicer value = 2024-07-01 without having to go into the report, change the slicer value, save the report, and republish.
Thanks!
Solved! Go to Solution.
This is the standard pattern in such a scenario:
- create a string representation of your date column, replace the latest date with a string "Latest"
- sort that new column by the original date column
- add a slicer or visual/page/report level filter
- set the filter to "Latest"
- publish the pbix to the workspace/app
This is the standard pattern in such a scenario:
- create a string representation of your date column, replace the latest date with a string "Latest"
- sort that new column by the original date column
- add a slicer or visual/page/report level filter
- set the filter to "Latest"
- publish the pbix to the workspace/app
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
105 | |
105 | |
88 | |
61 |
User | Count |
---|---|
165 | |
133 | |
132 | |
95 | |
86 |