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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
hello everyone,
i ceated a line chart:
all is correct im not facing issues but all i want is the first line per product to go from 0 so expected result:
the line should alwayss go from 0 to the number per product on the first appearance
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))