Single Select Slicer with Default Option

[Sonashish]

Hello In my powerBI report I am using Single Select Slicer on Year field. In the slicer dropdown, I want to add "Select Year at the top and by default it this option should be selected or when I reset the filter this option should get selected.

How Can I do this?

Regards

Sona

[Anonymous · Accepted solution]

Hi  @Sonashish  ,

You can use the isfiltered function

According to your description, I created some data:

Here are the steps you can follow：

1. Create measure to calculate the amount of a column when selecting a year

select_year =
var _select=SELECTEDVALUE('Table'[Year])
return CALCULATE(SUM('Table'[amount]),FILTER('Table','Table'[Year]=_select))

Result：

The default is blank ()

2. Use isfiltered to create measure. The default value is 2017

ISFILTERED =
IF(ISFILTERED('Table'[Year]),'Table'[select_year],CALCULATE(SUM('Table'[amount]),FILTER('Table','Table'[Year]=2017)))

Result：

The default value is 2017

You can downloaded PBIX file from here.

Best Regards,

Liu Yang

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

[Sonashish]

Thanks Liu, I implemented your implementation. It seems to be working.

Thanks

[Sonashish]

Hello Liu,

Thanks for reply. I have two single select slicer as mentioned

1st Slicer (Year) = It always select first value

2nd Slicer (Country) = It also always select first value

What I was looking for give option Select Year and Select Country. Because as this single select slicer so by default one option is always selected. I dont want to default option or first valus should always select until end user select. That is why I was looking for add Select Year and Select Country. If this not possible then is there any way to not select first value as default value. I also added a button (reset all filters) using bookmark action. So once user click on this button so any value which is selected in these two slicers, both should be unselect.

Please advise

Sonashish

[Anonymous]

Hi  @Sonashish ,

Currently, we can't set the default value for slicers, because DAX is not available in the report level filter panel. If you want the default value to be the current year, you can create a new calculated column to represent "yesterday" or "other dates", and then use this column to filter the chart.

This is related content, I hope it can help you:

https://businessintelligist.com/2016/04/15/power-bi-tutorial-dynamically-update-date-slicer-to-show-...

https://community.powerbi.com/t5/Desktop/Setting-a-Default-Value-for-a-Slicer/td-p/440659

https://community.powerbi.com/t5/Service/Default-value-in-Report-Filter-Panel/td-p/47574

Best Regards,

Liu Yang

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