Slicer to Display Lower Level Report

Question

Complete Hierarchy Table B with all Regions / Markets / States / City's&nbsp;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&nbsp;RegionMarketStateCity&nbsp;&nbsp;&nbsp;NortheastNew EnglandMassachusettesBoston&nbsp;&nbsp;&nbsp;NortheastNew EnglandNew HampshireConcord&nbsp;&nbsp;&nbsp;NortheastNew EnglandMaineAugusta&nbsp;&nbsp;&nbsp;NortheastNew YorkNew YorkAlbany&nbsp;&nbsp;&nbsp;WestWest-SouthCaliforniaSan Diego&nbsp;&nbsp;&nbsp;WestWest-NorthWashingtonSeattle&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Slicer for Each Column&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Region&nbsp;Market&nbsp;State&nbsp;CityNortheast&nbsp;New England&nbsp;Massachusettes&nbsp;BostonWest&nbsp;New York&nbsp;New Hampshire&nbsp;Concord&nbsp;&nbsp;West-South&nbsp;Maine&nbsp;Augusta&nbsp;&nbsp;West-North&nbsp;New York&nbsp;Albany&nbsp;&nbsp;&nbsp;&nbsp;California&nbsp;San Diego&nbsp;&nbsp;&nbsp;&nbsp;Washington&nbsp;SeattleWhen NorthEast Region is Selected the visual will show as below&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MarketMetric1Metric2&nbsp;&nbsp;&nbsp;&nbsp;New England11%1,111&nbsp;&nbsp;&nbsp;&nbsp;New York22%2,222&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;When New England Market is Selected the visual will show as below&nbsp;&nbsp;StateMetric1Metric2&nbsp;&nbsp;&nbsp;&nbsp;Massachusettes33%3,333&nbsp;&nbsp;&nbsp;&nbsp;New Hampshire44%4,444&nbsp;&nbsp;&nbsp;&nbsp;Maine55%5,555&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

greg_deckler · Answer

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
&nbsp;

amitchandak · Answer

eopage18 ,
&nbsp;
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/
&nbsp;

eopage18 · Answer

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 · Answer

Hi eopage18&nbsp;，After my investigation, I didn't find any other visuals suitable for your scenario except the hierarchical Filter as suggested by amitchandak.Best RegardsRena

Forum Discussion

Slicer to Display Lower Level Report

4 Replies

Related content

Image display in Power bi report

How to Display Slicers Horizontally

Display report runtime in report

language slicer in powerbi report

Visual Display based on Filter/slicer election

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