Forum Discussion
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
- Daily
- Year
- Month
- Date
- Weekly
- Year
- Month
- Week Number
- Monthly
- Year
- Month
- Yearly
- Year
- FY Year
- 1.FY Year
'X Axis Set 2' have 4 values and respective table column in it
- Last Week
- Year
- Month
- Date
- 2.Last Month
- Year
- Month
- Date
- 3.Last Year
- Year
- Month
- Date
- Last FY Yearly
- Year
- Month
- 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
- lbendlin
Super User
Combine your two field parameters into a single one.
- BalajiS193Frequent 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