Forum Discussion

PBI_newuser's avatar
PBI_newuser
Post Prodigy
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 PBI_newuser ,

     

    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

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

        Hi PBI_newuser ,

         

        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.