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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

show only child values based on parent selection

Hi All,

I am trying to create a chart that shows the values of all the child under the parent when it is selected in the filter.

For example when I select Continent (example: Asia), it should only show me the Sub Continents (example: Central Asia, Eastern Asia...etc) in the chart.
And the same for when I select Sub-Continent (Example: Southern Asia) it should only show the countries in Southern Asia (Afganistan,Bangladesh, Bhutan....etc) in the chart.

Unfortunately, I cannot only rely on the expand next level function on the chart to do it and need it to automatically change based on the selection.

Please kindly let me know if there is a way I can do it with a Dax Measure or any other way. 

 

This is what it shows:

samorshe_0-1599604524049.png

But I want to show it like this with out having to press the next level button on the chart. 

 

samorshe_1-1599604578385.png

 

Thanks

8 REPLIES 8
v-eqin-msft
Community Support
Community Support

Hi @Anonymous ,

Maybe you could select the hierarchy in Axis directly as below

9.9.5.1.1.png

And for Slicer ,edit interactions so that it will not filter other visuals.

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

 

9.9.5.2.png

You could take a look at my pbix file here

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please upload some insensitive data samples and expected output.

 

Best Regards,

Eyelyn Qin

Anonymous
Not applicable

HI All,

 

Thank you for the response.

Please find some of the details requested for my question. 

I have attached a link to the PBIX file. 

Link: https://drive.google.com/file/d/1HTt33Y5s-FhzWDXt9-GJeZw0_R-gMqS8/view?usp=sharing

 

The data is from UN migration database

 

Here is a snippit of my data:

samorshe_0-1599682844231.png

what I am trying to do is create a watefall chart that shows the different levels under the hierarchy.

 

For example, when I select ASIA from the filter this is what the chart shows:

samorshe_1-1599683402944.png

but I want it to show like this, without selecting the expand next level button:

samorshe_2-1599683456424.png

then if i choose Central Asia or any other Sub Continent- it shows me the below:

samorshe_3-1599683607804.png

But instead i want it to show me all the cities with in Central Asia without using the expand next level button. 

samorshe_4-1599683659249.png

Please kindly let me know if you need any more information, but the PBIX file has the data in it. technically it is very simple to do with the expand next level button on the chart but I cannot use that button for the pursposes of my dashboard. 

 

Please let me knoe if there is any other solution to it. 

 

Thanks

amitchandak
Super User
Super User

@Anonymous , Not very clear.

 

See if this example can help https://www.youtube.com/watch?v=7DW5wD2j1xw

Greg_Deckler
Super User
Super User

@Anonymous - What does your source data look like?

Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@Greg_Deckler 

 

I have provided more info as requested. Please kindly let me know if you need anything else to help me with the issue. 

Thanks in advance for you help. 

Thanks

@Anonymous Sorry, I am not typing all that data into an Enter Data query in order to mock this up.

 

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@Greg_Deckler 

I shared the PBIX file throught a link in my post. Are you not able to open it ?

 

Link; https://drive.google.com/file/d/1HTt33Y5s-FhzWDXt9-GJeZw0_R-gMqS8/view?usp=sharing

 

Sory this is the first time I am posting so not totally sure of another way to share my data. 

 

i will also input some sample data using the table function tonight. 

Thanks

 

@Anonymous Sorry, missed that link in the middle of that post. I'll see if I can take a look.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.