Forum Discussion

kompalli's avatar
kompalli
Helper I
3 years ago
Solved

Slicer based default selection on another slicer

Hi All,    I was trying to create a slicer based default selection on another slicer. To tell it more clear I have country slicer and time aggregation slicer(MTD,YTD & MAT). If I select India ln c...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , kompalli 

    Thanks for your quick response. In my understand you can refer to this:
    I create a table like this:

    This means when we select the "a", we can just select the "4,5,6" and for your need , it will be selected by the "4" by defalut.

    (1)We need to create a table like this:

    (2)Then we create a measure:

    Flag = 
 var _product = SELECTEDVALUE('Table'[Product])
 var _cur_month =FILTER(ALL('Table') , [Product] = _product)
var _min_month = MINX(_cur_month , [Month])
var _slicer =SELECTEDVALUE('Table'[Month])
return
IF( ISFILTERED('Table'[Product]) && _slicer = _min_month ,TRUE(),FALSE())

    (3)Then we put the 'Table'[Product] in system slicer and put the other filed in the "Preselected slicer":

    (4)Then we can get the result is as follows:

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

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

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi , kompalli 

According to your description, you want to realize that when we select the first slicer then the second slicer show the the corresponding option.

First of all, for your needs, if we want to affect the choice of one slicer to affect the choice of another slicer, then we need these two fields to have a hierarchical relationship, and we can create a new table to define this hierarchical relationship.Then we can re-create the measure and the use the past measures to get the value we want .

 

Second, the default slicer in Power BI does not have the function of default selection, if you need to implement the default selection, you can try to use "Preselected slicer".

For more information, you can refer to :
Solved: How to set last 2 months as default filter in a po... - Microsoft Power BI Community

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

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

  • kompalli's avatar
    kompalli
    Helper I
    3 years ago

    Hi v-yueyunzh-msft ,

    Thankyou for the reply and suggestion I will work on it. It is really very helpful.

  • kompalli's avatar
    kompalli
    Helper I
    3 years ago

    Hi v-yueyunzh-msft ,

     

    I have gone through the approach and checked preselected slicer as well. Still I couldn't achieve the exact required result.

    • As mentioned I am trying to implement slicer based default slicer selection.Above is the example of two slicers one is product and other is Month Name.
    • If I select a particular product Amarlia then this selection should effect the change in other slicer based on what should be seen.  In this case Product is Amarlia and default should be April.
    • In the same way based on each product selection. I need some preselected selection of "month" that should be shown by default when product is being changed and at the same time I should be able to chnage to other month as well.

    Please suggest some other alternative approaches if possible.


    Thanks in advance.

    • v-yueyunzh-msft's avatar
      v-yueyunzh-msft
      Community Support
      3 years ago

      Hi , kompalli 

      Thanks for your quick response. In my understand you can refer to this:
      I create a table like this:

      This means when we select the "a", we can just select the "4,5,6" and for your need , it will be selected by the "4" by defalut.

      (1)We need to create a table like this:

      (2)Then we create a measure:

      Flag = 
 var _product = SELECTEDVALUE('Table'[Product])
 var _cur_month =FILTER(ALL('Table') , [Product] = _product)
var _min_month = MINX(_cur_month , [Month])
var _slicer =SELECTEDVALUE('Table'[Month])
return
IF( ISFILTERED('Table'[Product]) && _slicer = _min_month ,TRUE(),FALSE())

      (3)Then we put the 'Table'[Product] in system slicer and put the other filed in the "Preselected slicer":

      (4)Then we can get the result is as follows:

      Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

       

      Best Regards,

      Aniya Zhang

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

      • SahityaYeruband's avatar
        SahityaYeruband
        Helper II
        1 year ago

        v-yueyunzh-msft 
        I am trying the same solution, but when I select other products - say b,c,d, the default value isn't getting selected.
        Can you please let me know what needs to be done?