Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Slicer Filtering issue using single select

Hi all,

 

I have two slicers on my report that are "Single Select". The two slicers are Sub and Geo.  Some subs have two geos while others have one. The problem I face is if I slice on Sub then slice to a geo some of the subs disapear from the sub slicer. Also I dont want to show all Geos all the time because there wont be data for every geo for every sub. Any ideas on how to get around this?

 

Thanks!

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    Anonymous looks like you have sub and geo coming from the same table, if that is the case, you need to create a separate dimension for the sub and geo so that they don't filter each other, and to list only geo with the selected sub and have a data, you need to create a measure and use visual level filter, something talked in this post.

     

    ✨ Follow us on LinkedIn

     

    Learn about conditional formatting at Microsoft Reactor

    My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

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

    Hi Anonymous ,

     

    If Sub and Geo are combined, can the hierarchyslicer meet your needs?


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