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

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?