how to display the result for child filter on click of parent filter

[Sid25]

I wanna display the result of the next filter on click of parent filter and so on...

[amitchandak]

@Sid25 , refer if this can help.https://www.youtube.com/watch?v=cyOquvfhzNM

If they are in the same table you can create a hierarchy. Do create dependencies

create a new hierarchy
https://www.tutorialgateway.org/create-hierarchy-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTY

[Sid25]

Sorry to bother you again but I am kinda newbie to this tool and mostly work with R and Python and did not understand the video or above-given references. and I have a single table so the relationship is no longer required in this case.i have created all the filters from that very same.

what I wanna do is to render the chart of other filters on click on the first filter.let's say I have a dataset of the districts and blocks within distinct districts and centers within those distinct blocks and so on. when I click on filter1 then it just renders that specific chart for that district, this is not what I want, what I really want is to render or display the chart of blocks on click of the district(blocks which are within that district). or It automatically selects all those blocks for it and displays the chart on click of the district and the same for the block to render the chart of distinct centers on click of a particular block.

Let's say the dataset really looks like this...

PID  name        district         blockname     centrename              status 

101  kelly          Indiana          Carmel        jenny &james             yes

102  Jennifer     Mississippi    Laurel          Dat Pvt                       No

103  Margot      L.A.                LA              Marilyn Pvt                 yes

104  Sia             Ohio             Akron          Chris Pvt                    No

105  Halie          Florida         Tampa          dexter Pvt                 No

please, guide me through to get it done, any help would be great.

[v-yingjl]

Hi @Sid25 ,

"I really want is to render or display the chart of blocks on click of the district(blocks which are within that district). or It automatically selects all those blocks for it and displays the chart on click of the district and the same for the block to render the chart of distinct centers on click of a particular block."

Still not certain what is your expected output, can you give a specific example based on your dataset for further disccssion?

Best Regards,
Yingjie Li

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

[Sid25]

what I want is to render the chart of the second filter by clicking on the selection of the first filter. the first filter contains the state and the second one contains the cities of that state.let's say I select Arizona from filter1 which should select all the cities of its cities and display the chart for cities not show the state name Arizona itself in the plot area.

dummy data somewhat looks like this...

city	city_ascii	state_id	state_name	county_fips	county_name	county_fips_all	county_name_all
South Creek	South Creek	WA	Washington	53053	Pierce	53053	Pierce
Roslyn	Roslyn	WA	Washington	53037	Kittitas	53037	Kittitas
Sprague	Sprague	WA	Washington	53043	Lincoln	53043	Lincoln
Gig Harbor	Gig Harbor	WA	Washington	53053	Pierce	53053	Pierce
Lake Cassidy	Lake Cassidy	WA	Washington	53061	Snohomish	53061	Snohomish
Tenino	Tenino	WA	Washington	53067	Thurston	53067	Thurston
Jamestown	Jamestown	WA	Washington	53009	Clallam	53009	Clallam
Three Lakes	Three Lakes	WA	Washington	53061	Snohomish	53061	Snohomish
Curlew Lake	Curlew Lake	WA	Washington	53019	Ferry	53019	Ferry
Chain Lake	Chain Lake	WA	Washington	53061	Snohomish	53061	Snohomish
Pateros	Pateros	WA	Washington	53047	Okanogan	53047	Okanogan
Rosburg	Rosburg	WA	Washington	53069	Wahkiakum	53069	Wahkiakum
Parkland	Parkland	WA	Washington	53053	Pierce	53053	Pierce
Birch Bay	Birch Bay	WA	Washington	53073	Whatcom	53073	Whatcom
Ashford	Ashford	WA	Washington	53053	Pierce	53053	Pierce
Navy Yard City	Navy Yard City	WA	Washington	53035	Kitsap	53035	Kitsap
Omak	Omak	WA	Washington	53047	Okanogan	53047	Okanogan
Farmington	Farmington	WA	Washington	53075	Whitman	53075	Whitman
Buckley	Buckley	WA	Washington	53053	Pierce	53053	Pierce
Cathcart	Cathcart	WA	Washington	53061	Snohomish	53061	Snohomish
Poulsbo	Poulsbo	WA	Washington	53035	Kitsap	53035	Kitsap
Anacortes	Anacortes	WA	Washington	53057	Skagit	53057	Skagit
Maplewood	Maplewood	WA	Washington	53053	Pierce	53053	Pierce
Creston	Creston	WA	Washington	53043	Lincoln	53043	Lincoln
Rockford	Rockford	WA	Washington	53063	Spokane	53063	Spokane
Wishram	Wishram	WA	Washington	53039	Klickitat	53039	Klickitat
Centralia	Centralia	WA	Washington	53041	Lewis	53041	Lewis
South Hill	South Hill	WA	Washington	53053	Pierce	53053	Pierce
Longview Heights	Longview Heights	WA	Washington	53015	Cowlitz	53015	Cowlitz