Solved: Creating Sub Filters within a new group

I-Jay-I · ‎07-04-2019

Hi All,

I have a set of data which has three columns, Name, Country and Price as shown in the picture below.

I have made a new column called Country (groups) where I have created a slicer so that the people who are in that region (ie Europe) are shown. So for example when I select Asia, Fred and Hannah are shown for Japan (JP) and Omara and Rupi are shown for Russia (RU).

However I would like to find a way so that when I select Asia in the Country (groups) filter it then shows Fred, Hannah, Omara and Rupi as singular clickable options so that they can selected individualy. Essentially I am looking to create something similar to the below picture. Can anyone help!?

Thank you in advance!

Jay

v-chuncz-msft · ‎07-05-2019

@I-Jay-I

You may simply use HierarchySlicer.

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380820?src=office&tab=Overview

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎07-05-2019

@I-Jay-I

You may simply use HierarchySlicer.

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380820?src=office&tab=Overview

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.