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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
zraptor
Frequent Visitor

How to adjust dates on X axis of chart?

Hello experts!

 

Quick question, I have a bar chart that displays a week worth of data of which the dates on the X axis come from a calendar table.  When I choose a date from a slicer on the page, the values adjust accordingly BUT I need the X axis to adjust to only show the selected date and not the entire week range.  Below is the chart after 1 date is chosen....

 

zraptor_0-1674760536827.png

 

I'd like the dates at the bottom to only be that of the chosen slicer value.

2 REPLIES 2
SivaMani
Resident Rockstar
Resident Rockstar

@zraptor, there could be different reasons for this behaviour,

  1. Model - Relationships
  2. The Calculation
  3. The fields used in the visuals

Can you share how the bar chart is related to the slicer? Do they have dates coming from the same table?

@SivaMani , absolutely!  Thank you!

So the dates on the X Axis are in a 1 column date/time table.  They Y axis data is a count of employees from another table which contains clock in/out data.  The tables aren't related in modeling.  Instead I am using a measure to get the count of employees.  The "Date" slicer is a date field on the Employee clock in/out table.  Just by typing this out I am realizing that maybe the problem is that I am using the date column on the wrong table?  The measure for the employee count is below.

OnClockCount=

VAR _time = MAX('DateTimeIntervals'[DT])
RETURN
CALCULATE(
sum('Data'[EMP Count]),
    FILTER(
        Data,
        Data[ClockinDT]<=_time
            &&Data[ClockoutDT]>=_time + TIME(0, 10, 0)
    )
)


  

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.

Top Solution Authors