Automatically Update Month according to Last Refresh Date

[piyushjain0304]

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?

[v-yuta-msft]

@piyushjain0304 ,

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.

[piyushjain0304]

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?

[v-yuta-msft · Accepted solution]

@piyushjain0304 ,

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.

[piyushjain0304]

Can we just update the slicer to last month and include all other months also? Client wants to see it that way?

[nahid3152]

HI,
u can use 

SlicerCheck = if(calculate(distinctcount([Month]),allselected(MASTERCalender[Month]))=1,"Y","N") for month use it on the filter on this visual part