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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
akkolbeck
Frequent Visitor

How to freeze my x-axis so it doesn't only show columns with data

I am running HR data and our leaders want to see termination counts by period. What is currently happening is that when I select a group via a Slicer, it's only showing the periods where terminations took place. What I want is for my leaders to be able to see is all periods, even if there were no terminations, so they can get a better look at trends throughout the year.

 

I am using slicers and simple bar charts. 

Axis = Period

Value = Count of Employee ID (for number of terms by each period)

 

I tried to turn on the function "show items with no data" but that didn't work

 

Any assistance would be appreciated!

 

thank you!

1 REPLY 1
Anonymous
Not applicable

Consider using a DimDate table per a very similar discussion yesterday - see Re: How to align X axis of multiple charts? (addin...

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.