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!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
Hi, I would like to create a graph like the one below qhich is showing the count of persons by tenure at a business firm. How can I get the x axis like this. think I do have an idea of how to calculate the values by calculating the date difference between start date and end date for the number of years and do a count for earch xaxis series.
Solved! Go to Solution.
make barckets of your tnure like the following
Bracker =
SWITCH(
TRUE(),
Table3[Tenure] >=0 && Table3[Tenure] <= 1, "0-1",
Table3[Tenure] > 1 && Table3[Tenure] <= 2, "1-2",
Table3[Tenure] > 2 && Table3[Tenure] <= 5, "2-5",
Table3[Tenure] > 5 && Table3[Tenure] <= 10, "5-10",
"> 10"
)
@Sagejah9
You can add a new column in your table as follows
Create the following measure, add the new column to X axis and the measure to the value.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
make barckets of your tnure like the following
Bracker =
SWITCH(
TRUE(),
Table3[Tenure] >=0 && Table3[Tenure] <= 1, "0-1",
Table3[Tenure] > 1 && Table3[Tenure] <= 2, "1-2",
Table3[Tenure] > 2 && Table3[Tenure] <= 5, "2-5",
Table3[Tenure] > 5 && Table3[Tenure] <= 10, "5-10",
"> 10"
)
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 63 | |
| 51 | |
| 41 | |
| 20 | |
| 16 |
| User | Count |
|---|---|
| 122 | |
| 106 | |
| 47 | |
| 30 | |
| 24 |