Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
BalajiS193
Frequent Visitor

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 2
lbendlin
Super User
Super User

Combine your two field parameters into a single one.

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

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.