Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dynamic Table Columns With Slicer Using Field Parameters

Hi, I have a table visual that is controlled by slicer and both table & slicer are using field parameters. It’s working fine but I would like to modify the slicer. The slicer currently has 9 values:...
Help
  • d_gosbell's avatar
    d_gosbell
    3 years ago
    Anonymous wrote:

    Hi d_gosbell and Shaurya , thanks for the feedback. That works but this is not the result I'm looking for. I need the columns to appear when value in slicer is selected and if no values selected, then columns are hidden.

    This is my solution working the way you've described. I've put a revenue and comparative measure in the values and created a slicer for the category

     

d_gosbell's avatar
d_gosbell
Super User
3 years ago

I don't think you even need a field parameter to solve this.

 

If you create a table with your 3 values (I just called it category)

 
Category = DATATABLE("Category", STRING, {{"Kiosk"},{"TEX"},{"Online"}})
 
Then as Shaurya suggested you can create measures checking for the selected value in the slicer (I would make the slicer a single selection). This is an example revenue measure, you would repeat the same pattern for Comparative and Variance.
 
Revenue = SWITCH( SELECTEDVALUE(Category[Category]),
    "Kiosk", 'Vend_Sale'[Revenue SUMX],
    "TEX",'mm_sheets'[Current Year Pax SUMX],
    "Online", 'Vend_Sale'[Transaction Count SUMX],
    blank())
 
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi d_gosbell and Shaurya , thanks for the feedback. That works but this is not the result I'm looking for. I need the columns to appear when value in slicer is selected and if no values selected, then columns are hidden. Hence the field paramter method I chose.

 

Can I use integrate your method using the field parameters? I'll have a go but please do let me know if you find a quicker method. Thanks. 

  • d_gosbell's avatar
    d_gosbell
    Super User
    3 years ago
    Anonymous wrote:

    Hi d_gosbell and Shaurya , thanks for the feedback. That works but this is not the result I'm looking for. I need the columns to appear when value in slicer is selected and if no values selected, then columns are hidden.

    This is my solution working the way you've described. I've put a revenue and comparative measure in the values and created a slicer for the category

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      d_gosbell , don't know what I did wrong the first time, but it's working for me now...without the need for field parameters. 

       

      Many thanks for your help and patience. Appreicate it.