Forum Discussion
Automatically Update Month according to 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.
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?