Forum Discussion

shubhamc_002's avatar
shubhamc_002
Helper I
3 years ago

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

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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's avatar
      shubhamc_002
      Helper I
      3 years ago

      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