Forum Discussion
show only child values based on parent selection
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:
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:
but I want it to show like this, without selecting the expand next level button:
then if i choose Central Asia or any other Sub Continent- it shows me the below:
But instead i want it to show me all the cities with in Central Asia without using the expand next level button.
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