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.