Slicer to Display Lower Level Report

[eopage18]

Complete Hierarchy Table B with all Regions / Markets / States / City's

When a User selects a Level from a Slicer such as a Region (Northeast) the report will then display all Markets from Table B for that selected Region and should Market be selected all States will be shown from Table B should State be selected all City's would be shown from Table B

Region	Market	State	City
Northeast	New England	Massachusettes	Boston
Northeast	New England	New Hampshire	Concord
Northeast	New England	Maine	Augusta
Northeast	New York	New York	Albany
West	West-South	California	San Diego
West	West-North	Washington	Seattle
Slicer for Each Column
Region		Market		State		City
Northeast		New England		Massachusettes		Boston
West		New York		New Hampshire		Concord
		West-South		Maine		Augusta
		West-North		New York		Albany
				California		San Diego
				Washington		Seattle
When NorthEast Region is Selected the visual will show as below
Market	Metric1	Metric2
New England	11%	1,111
New York	22%	2,222
When New England Market is Selected the visual will show as below
State	Metric1	Metric2
Massachusettes	33%	3,333
New Hampshire	44%	4,444
Maine	55%	5,555

[amitchandak]

@eopage18 ,

Can you check hierarchical slicer in be 2020 release , if that is one can solve your purpose

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2020-feature-summary/

[eopage18]

The Hierarchy Slicer is a nice feature but the problem is getting a visual to update to the level below the selected value.  Such as, should a Region of Northeast be selected than the visual would only show the Markets with the Northeast region and their attributed metrics.  I am not seeing ghow the Hierarchy Slicer would operate for such a task?

[Anonymous]

Hi @eopage18 ，

After my investigation, I didn't find any other visuals suitable for your scenario except the hierarchical Filter as suggested by @amitchandak.

Best Regards

Rena

[Greg_Deckler]

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