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

Hierarchy look up in matrix

Hi,

I want to implement a hierarchy (Level 8- Level 1) in a matrix visual. These levels are the area name in a country like (territory->>district etc.) and want to show the sales amount. I have these 8 slicers over there in the report as well,  when I select a low level of being from the slicer; What I am seeing there the particular sales data for that level and below that level as well ; and that is fine. but the problem is with the level above the selected level. It's showing the same data to the above levels which I want to hide from the matrix.

Please follow the screenshots.scs1.jpg

 

scs2.jpg

Here you can see when I choose an area from the slicer I am seeing the accounts for this area 19507 (for below level it is segregated according to the district and territory) which is correct but the level above I am seeing the same number of account until the last level which I want to hide (when I select a level then I want to see the respective level data and the below only).

In the second screenshot you can see the data with slicing and that is all correct.

 

Please suggest How can I hide the data as per the above description.or can we use alternate to show this information.

 

Thanks in advance!!

 

Vishal

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Hierarchy look up in matrix

Hi pindivi,

I am not clear about your requirement, so if possible, could you please inform me more detailed information ( your sample and your expected output)? Then I will help you more correctly.

Best Regards,
Zoe Zhi

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

Highlighted
Frequent Visitor

Re: Hierarchy look up in matrix

@pundivi  Understood your requirement.

 

You need to understand the concept here, since you have selected  'Carolinas Area' the data is restricted to 'Carolinas Area' the sum up to the hierarchy will be the value available in 'Carolinas Area'.

 

Since you are showing the list in your matrix, why do u need a filter ? You can make the filter and the chart independent using 'Edit Interactions'. That way if someone selects the filter, your chart will not change.

 

Hope this helps 🙂

 

 

 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors