Field Parameter | Selective Fields Display

[shubhamc_002]

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. 
eg: 

Slicer 1 having value,
val1

val2

val3

val4

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.

Thanks

[amitchandak]

@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"} ) ),

countrows(Table)

)

Use in the visual level filter of field paremeters

[shubhamc_002]

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. 

Eg: 

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). 

Thanks