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?   Product Sales Team Country AAA ...
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.

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

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    PBI_newuser , Visual level filter on slicer not <> US or not in US.

    Or Page level filter