Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Memorable Member
Memorable Member

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.



Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

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
Memorable Member
Memorable Member

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.



Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!
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?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

Check out the March 2024 Power BI update to learn about new features.