Show the first value in single select slicer in Power BI report as default value

[supriyakhamesra]

I am having a Power BI report which have a single select slicer . The data in the slicer is updating dynamically and want that whenever a report is rendered the top most value should always be selected and repective data should get displayed. But currently when the data get updated it always shows the last selected value even if it is not there in the list. So, need to resolve this issue and always want the top most value to be default selected.

[v-xinruzhu-msft]

Hi @supriyakhamesra 

You can try to use custom visual :preselected slicer

 please get it from visual store

e.g put the date into the slicer, then create a new measure to get the latest date

Measure 2 = var _slicer=SELECTEDVALUE('Table'[Date])

var _max=MAXX(ALL('Table'),[Date])

return

IF(_slicer=_max ,TRUE(),FALSE())

Then put it into the visual field,

Create a new table

Then put the field into the visual field, it can realize the default choice

^{Best Regards,}

^{Yolo Zhu}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}

[supriyakhamesra]

Hi ,

I tried preselected slicer. Initially it appeared to work . But when my data get refershed and and there is no older value and only new single value is there then the updated value is appearing but is not default selected. On refreshing the data in Power BI desktop too it is not default selected with the latest value. Any idea what can be the issue.

[sudhav]

Just try it, i am not sure, in slicer, you can use relative date or relative time method, here you can select last one hour data/last n hours data/last 1 day/last week/last 1 month/this week/this month data like this... just try it if yr data is getting update by weekly or monthly or daily or hourly.....

please let me know if its works....

[ibarrau]

Hi. There is no feature in PowerBi that will let you change the value of a slicer dynamically to set a default value. You need to find other place to create that dynamic filter, like the transformations of your dataset. You could filter that on PowerQuery, but that means only showing data for that filtered data.

The only approach I can think now would be build a custom column at your data that could identify the entity you want to filter if it's the top most value, like a flag (0 or 1 or any text to filter the value). Then just add that slicer next to the one you have now. It might be more user friendly if it's a text, slicer with two values "Top Most Value", "Other Values". That slicer can be saved as the default of the user and the data will change but the selection wouldn't. At the end you need to let the other filter a select all or none selection to let this one work.

I hope that helps,