Slicer default value update to last item in the list

[Anonymous]

Hi all, 

I have a table with 6 items and i created a slicer based on this table. This table is updated everymonth with a new item added inside. The question here is how to update the slicer default value to the latest item added in every month right after data refreshed . 

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

No, it couldn't achieve that set a default value for a slicer, becasue when you log out of Power BI and come back to a report, the same items will be selected as when you left.

here is the idea, please see detailed explanation in it:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7162004-default-selected-slicer-or-tile-by-value-configura

As a workaround, you add a tag column (if it is the lasted date from calendar table), then use it as a filter(slicer or visual/page/report level filter ).

Best Regards,

Lin

[copykai]

Hi masonl,

As far as I know, there is not a possibility to add a default value for a slicer dynamically.

The only way to do so is that you pick the latest value each month and republish the file.

Best regards

Kaj