Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

All selected values in the slicer

Hi ,

I need to create a dash with the funtionallity that if we exclude any values from the slicer , the entire board will need to change and recalculate without these values. 

I did this as a slicer by selecting everything and when you need to select any value to exclude you need to uncheck or un select the box or boxes.

 

 

The question is there is a better solution to show the selection of the excluded values (as normal way) and create a new table in order to see all selected values .

 

Thanks

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

    Hi , Anonymous 

    Thank you for your quick response.According to your description, you want to show the excluded data in the table. Right?

    Here are the steps you can refer to :

    (1)This is my test data in ‘Table’:

    (2)We can click “New Table” to create a table:

    Table 2 = ALL('Table')

    (3)Then we can create a measure as a flag to filter the data in the visual:

    Measure = var _slicer = VALUES('Table'[ID])
var _curID=MAX('Table 2'[ID])
return
IF( _curID in _slicer ,0,1)

     

    (4)Then we configure it on the “Filter on this visual” and we can meet your need:

    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 , Anonymous 

    According to your description, you want to show the data exclue the slicer filter you selected . Right?

    For you need , i recommned you to use the custom viusal "Mass Slicer".

    You can click the three dot in the "Visualization" and click "Get more viusal":

    You can add the "Mass Filter" in it.

    For this visual , you can enter what you want to filter or exclude the filter by clicking this buttion:

     

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi ,

    This solution is ok , but not so clear because I need to write whole number or category that I need it.
    So the best idea is create a new on the fly table with all items not selected from the slicer (remember that the items in the slicer should be in select all mode )

    Thanks 

     

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

      Hi , Anonymous 

      Thank you for your quick response.According to your description, you want to show the excluded data in the table. Right?

      Here are the steps you can refer to :

      (1)This is my test data in ‘Table’:

      (2)We can click “New Table” to create a table:

      Table 2 = ALL('Table')

      (3)Then we can create a measure as a flag to filter the data in the visual:

      Measure = var _slicer = VALUES('Table'[ID])
var _curID=MAX('Table 2'[ID])
return
IF( _curID in _slicer ,0,1)

       

      (4)Then we configure it on the “Filter on this visual” and we can meet your need:

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi v-yueyunzh-msft 

        PREVIEW
        Thanks for your response , but I forgot to mention that this table has a category column if you choose Group A you will see all un selected values from each group. 

        In your case only can filter the all table .

        Thanks