Forum Discussion

kompalli's avatar
kompalli
Icon for Helper I rankHelper 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 country slicer by default MTD should be selected and I should be able to change another time aggregations as well.

Is there anyway to implement this.Any suggestions regarding this would be very helpful.

 

Thanks in advance 

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

5 Replies

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Icon for Community Support rankCommunity 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
      Icon for Helper I rankHelper 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
        Icon for Community Support rankCommunity 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