Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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....
I'd like the dates at the bottom to only be that of the chosen slicer value.
@zraptor, there could be different reasons for this behaviour,
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=
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 103 | |
| 80 | |
| 59 | |
| 51 | |
| 46 |