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

Dynamic hierarchy Visual Level selection by slicer selections

I have a scenario of three level hierarchy location (Region->Districts->Blocks).I want to see location wise values in the donut chart.But the requirement is when I select region ,donut is showing the value for complete region instead it should show values for all the districts in that particular region.

Like wise if a particular district is selected it should show all the values of block in that District.

And by default View it should reflect all the values of regions

Dax Measure:

sales_by-Level = If(Isfiltered(country[Region]),Calculate([Inqty_sum],'Level'[custom]="L1"),

                  If(ISFILTERED(country[District]),Calculate([Inqty_sum],'Level'[custom]="L0"),

Calculate([Inqty_sum],'Level'[custom]="L2")

))

By using the above Dax measure Now if I select Region in slicer its showing District values.

And If I select District its showing block values.But When I select Both (Region& District) its uanble to show the block values.

I Have attached the screenshots for better understanding in the link.

Please correct me.

Thanks

2 REPLIES 2
Super User IV
Super User IV

@heman 


Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?

_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Website   YouTube    LinkedIn
Frequent Visitor

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.