Hierarchy summarize table dynamically with filters

[Satya2804]

We have Level1, Level2, Level3 - a set of hierarchy columns and another dimension(N). Data is available at Level3 and N granularity. Need to create a chart using Level1 as dimension, by separating L2 level positives and negatives separately and have the chart to work with a filter on column N. Attached is an excel with the desired chart and mock data.

 https://www.dropbox.com/s/1jta84pbsykduzq/PowerBI_Q.xlsx?dl=0&copy_to_dropbox=true 

Was able to replicate chart by creating a summarize table of my source at L2 level to identify positives and negatives. But Summary table doesnt change dynamically based on filters on column N. 

Can any of the Pros help with a solution please?

[Anonymous]

Hi @Satya2804 ,

You may want a slicer with hierarchy or custom visual like Hierarchy Slicer.

Business Apps – Microsoft AppSource

If you are creating a calculated table, you cannot include the slicer values coming from your report.

Best Regards,

Stephen Tao

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