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

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
Eyelyn9
Community Support
Community Support

Hi @samorshe ,

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

samorshe
Frequent Visitor

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 IV
Super User IV

@samorshe , Not very clear.

 

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Greg_Deckler
Super User IV
Super User IV

@samorshe - 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!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




@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

@samorshe 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!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




@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

 

@samorshe 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!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors