Forum Discussion

BalajiS193's avatar
BalajiS193
Frequent Visitor
2 years ago

Need Help on dynamic X axis in Line chart

I have 2 field parameters named as

'X Axis Set 1' and 'X Axis Set 2'

 

'X Axis Set 1' have 5 values and respective table column in it

  1. Daily
    1. Year
    2. Month
    3. Date
  1. Weekly
    1. Year
    2. Month
    3. Week Number
  2. Monthly
    1. Year
    2. Month
  3. Yearly
    1. Year
  4. FY Year
    1. 1.FY Year

 

'X Axis Set 2' have 4 values and respective table column in it

  1. Last Week
    1. Year
    2. Month
    3. Date
  1. 2.Last Month
    1. Year
    2. Month
    3. Date
  2. 3.Last Year
    1. Year
    2. Month
    3. Date
  3. Last FY Yearly
    1. Year
    2. Month
    3. Date

In line chart I need to dynamically change these filed parameters in X Axis based on each slicer created for each filed parameter

example if slicer 1 for 'X Axis Set 1' is selected then Chart X Axis should be 'X Axis Set 1' file values

if slicer 2 for 'X Axis Set 2' is selected then Chart X Axis should be 'X Axis Set 2' file values

2 Replies

    • BalajiS193's avatar
      BalajiS193
      Frequent Visitor

      Thank you for your suggestion, i tried this but, required to show  2 different slicers , Set 1 values in drop down with single select and Set 2 Values in vertical buttons with single select , when i use in same Filed Parameters by default drop down slicer having defualt selection so my second slicer selection not working as expected