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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Imagine this situation:
I have 100 scenarios and I have their variance % values from -25% to 25% mostly and when I want to show the population
I created a calculated column with switch in dax to show 5% ranges here 0% | 5% we have 20 scenarios lets say.
and it looks good. However business wants to see in a line chart (fine) but they also wants to see x-axis constant lines
* where is 0% line
* 1SD, 2SD, 3SD lines
sure, but when I use bins I'm not able to add x-axis but y-axis constant? which doesn't bring any value to the visual
when I don't use the bins and use the original column instead. I have distinct values so i'm only seeing 1 or 2 scenarios that they have the same variance % and I can add x-axis constant lines but It's not what business want.
I'm not what I'm missing here?
I'm not sure If I can add a sample power bi file here? but since it's an easy dataset I didn't add any records here.
What's your thoughts on this? Is there any way around here?
Solved! Go to Solution.
Hey
I'm glad you answer because I questioned everything what I have done and I check what's the definition to have x-axis constant in the visual for the report? and I found the solution
solution: x-axis is not possible to make it a dimension which DOES NOT HAVE continuous records.
so, I changed the dimensions from text to numerical format and it works (Y)
thanks buddy!
@Bilhan_Bel X-axis constant lines only appear for numeric and date (same thing really) values on the x-axis. You can refer to this thread: Solved: x-axis constant line on line graph - Microsoft Fabric Community
Hey
I'm glad you answer because I questioned everything what I have done and I check what's the definition to have x-axis constant in the visual for the report? and I found the solution
solution: x-axis is not possible to make it a dimension which DOES NOT HAVE continuous records.
so, I changed the dimensions from text to numerical format and it works (Y)
thanks buddy!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 66 | |
| 48 | |
| 43 | |
| 26 | |
| 19 |
| User | Count |
|---|---|
| 198 | |
| 126 | |
| 102 | |
| 67 | |
| 50 |