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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Bilhan_Bel
Frequent Visitor

How to add x-axis constant lines in the distribution (histogram)

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?

1 ACCEPTED 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!

View solution in original post

2 REPLIES 2
Greg_Deckler
Community Champion
Community Champion

@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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

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!

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.