Forum Discussion

Sonashish's avatar
Sonashish
Resolver I
5 years ago
Solved

Single Select Slicer with Default Option

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 rese...
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.