Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Preselect slicer

Hi, I have the data below and I have created a slicer for Country.

How to pre-select for "US" for the data and user only allow to select other countries?

 

ProductSales TeamCountry
AAATeam AUS
BBBTeam BChina
CCCTeam BJapan
DDDTeam CGermany
EEETeam DDenmark
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi Anonymous ,

     

    First create a disconnected table, and create a measure to apply to the visual level filter.

    Please refer to this sample pbix.


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

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi amitchandak , how to make the "US" disappear from the slicer and only show other countries?

      • V-lianl-msft's avatar
        V-lianl-msft
        Community Support
        5 years ago

        Hi Anonymous ,

         

        First create a disconnected table, and create a measure to apply to the visual level filter.

        Please refer to this sample pbix.


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