Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Field Parameter | Selective Fields Display

Hi Team, 


I have used field parameter feature in our BI report , Its very good feature by which we can change the dimension of the visual dynamically. 


Wanted to check if we can display selective fields which are available in field parameter by using some external slicers. 

Slicer 1 having value,





and visual is mapped with Field parameter in X axis and Y axis is single measure(Sales). Field parameter having certain fields (Region,Market, Country, State) . Requirement is: 
when user click on val1 from slicer , It should only show region and Market. 
if user click on val2 from slicer , It should show Country and state.

if nothing is selected than default , all Region,Market, Country, State should display in visual. 

Consider Clustered Column chart for this. 


Any help would be appreciated.



Super User
Super User

@shubhamc_002 , Create a measure on the field parameter table to display the


Switch(Max(Table[Var]) ,

"Var1" , countrows(Filter(Table, Table[Param Name] in {"region", "Market"} ) ),

"Var2" , countrows(Filter(Table, Table[Param Name] in {"state"} ) ),





Use in the visual level filter of field paremeters


Thanks @amitchandak . 
This has resolved part of the problem. 

Apologies , I was not able to fully explain the scenario earlier. If we are mapping field parameter in X axis it enables the drilldown option in Visual. 


My requirement is if by some mechanism drilldown can skipped the unwanted fields based on slicer selection. 


field parameter Hierarchy  is Region->Market-> Country-> State  Now if I have selected val1 from slicer it should show Region->Market (no further drilldown from visual). 
if I have selected val2 from slicer it should show directly Country->State (Region->Market should skip). 



Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors