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.
Hello all,
We are showing sales data to our client and they want to see the latest month data every time the data is refreshed.Is there any way I can do it in the Slicer that every time the data is updated the slicer is updated to latest month?
Solved! Go to Solution.
So your requirement is to achieve the default value in the slicer, right? The slicer visual doesn't support this feature, however, there's a workaround in the similar thread below:
https://community.powerbi.com/t5/Desktop/Setting-the-Default-Value-of-a-Slicer/td-p/16442
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The slicer visual is based on the data column, if the data has been updated, the value in slicer will also be updated so you don't need to do anything in the slicer.
To achieve the latest month data, you can create a measure using dax like pattern below:
Result =
CALCULATE (
SUM ( Table[Data] ),
FILTER ( Table, Table = MAX ( Table[Month] ) )
)
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the reply. However this doesn't provide the solution that is required. Is there any way that slicer is updated and selected automatically to latest month based on last refresh date?
So your requirement is to achieve the default value in the slicer, right? The slicer visual doesn't support this feature, however, there's a workaround in the similar thread below:
https://community.powerbi.com/t5/Desktop/Setting-the-Default-Value-of-a-Slicer/td-p/16442
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Can we just update the slicer to last month and include all other months also? Client wants to see it that way?
HI,
u can use
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |