cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Buckswriter
Frequent Visitor

Slicer which when selected will automatically select a range

Hi,

 

I have a dashboard which contains a list of organisation names, but these exist within a hierarchy, e.g. all organisations belong to a region, and all regions belong to a country.

 

I would like to be able to have users select an organisation and have my visualisations automatically show the organisation selected, the region and also the country too.

 

The regions and country are all in the same list of organisations names, e.g.

 

England

Country

London

Region

South West

Region

South East

Region

South West London Healthcare Partnership

Organisation

Kent and Medway STP

Organisation

 

So, if I selected Kent and Medway STP I would automatically get South East and England as parent and grandparent in the hierarchy under which Kent and Medway STP 'sits'.

 

Does this make sense? I would imagine I'll need to create a table that shows the parent and grandparent for each organisation, but assuming that can be done quite simply, is the thing that I am hoping to achieve then possible?

 

Thanks,

 

RW

1 ACCEPTED SOLUTION
hnguy71
Solution Supplier
Solution Supplier

Hey RW,

 

wouldn't you want a dimension such as this:

 

OrganisationRegionCountry
Kent and Medway STPSouth EastEngland
South West London Healthcare PartnershipSouth WestSome Bogus Country

 

In this way, when you add this to a hierarchy slicer, you would get the required levels.

View solution in original post

3 REPLIES 3
v-xiaotang
Community Support
Community Support

Hi @Buckswriter 

The solution highly recommend is to modify your data structure, you can use the structure bellow, 

vxiaotang_0-1631263891598.png

 

 

Best Regards,

Community Support Team _Tang

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

hnguy71
Solution Supplier
Solution Supplier

Hey RW,

 

wouldn't you want a dimension such as this:

 

OrganisationRegionCountry
Kent and Medway STPSouth EastEngland
South West London Healthcare PartnershipSouth WestSome Bogus Country

 

In this way, when you add this to a hierarchy slicer, you would get the required levels.

View solution in original post

amitchandak
Super User
Super User

@Buckswriter , with the current data the hierarchy does not make sense. How do we reach to region based on the above data?



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!