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,
I have an issue that may be an easy fix but haven't been able to track down an answer online. If I have a dates between slicer, how can I make it so the slicer always has the max date selected after a refresh.
So, for example, I publish the report on 3/2 with the slicer set as 1/1 - 3/1. Then the dataset refreshes overnight, pulling in the data from 3/2. Now, when a user loads the report, I would like the slicer to be set to 1/1 - 3/2, not the 1/1 - 3/1 that I published the report as. Is this possible?
Solved! Go to Solution.
I believe I have found a solution. My current date table is created in power query. I created one in DAX. Due to the dynamicness of DAX, when the report refreshes with the new day, the report date slicers now include that day. Not sure why it's different functionality for DAX as opposed to the power query date table, but it worked.
I found this solution on an old post from 2018. I'm a dummy and didn't save the link to be able to give that person kudos.
Can you please provide a link to the solution, stuck with the same issue.
I believe I have found a solution. My current date table is created in power query. I created one in DAX. Due to the dynamicness of DAX, when the report refreshes with the new day, the report date slicers now include that day. Not sure why it's different functionality for DAX as opposed to the power query date table, but it worked.
I found this solution on an old post from 2018. I'm a dummy and didn't save the link to be able to give that person kudos.
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |