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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
eliasayyy
Memorable Member
Memorable Member

make my line chart start from 0

hello everyone, 

i ceated a line chart:

annonymous1999_1-1674138523681.png

 

all is correct im not facing issues but all i want is the first line per product to go from 0 so expected result:

annonymous1999_2-1674138581981.png

the line should alwayss go from 0 to the number per product on the first appearance




3 REPLIES 3
tamerj1
Super User
Super User

Hi @eliasayyy 

It could be possible. Can you please advise which columns are involved in this visual and from which tables? Specifically the x-axis

x-axis is month-year column formated from date

format(table[date],"MM-YYYY")

y axis is a formula measure to calculate sum by month-year

all from 1 table called table

which has 3 columns : date , product and sales

i added calculated column of
month-year
sorting

the measure is calculate(sum(table[sales]),datesbetween(date,startdate,enddate))

amitchandak
Super User
Super User

@eliasayyy , I doubt that is possible

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 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.