Forum Discussion

Buckswriter's avatar
Buckswriter
Frequent Visitor
5 years ago
Solved

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...
Need Help
  • hnguy71's avatar
    hnguy71
    5 years ago

    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.

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
5 years ago

Hi Buckswriter 

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

 

 

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.