Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Consider using a DimDate table per a very similar discussion yesterday - see Re: How to align X axis of multiple charts? (addin...
User | Count |
---|---|
87 | |
72 | |
69 | |
64 | |
54 |
User | Count |
---|---|
99 | |
91 | |
80 | |
74 | |
64 |