Slicer Filtering issue using single select

[Anonymous]

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!

[V-lianl-msft]

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.

[parry2k]

@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.⚡