topic make my line chart start from 0 in DAX Commands and Tips

make my line chart start from 0

eliasayyy — Thu, 19 Jan 2023 14:30:51 GMT

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

Re: make my line chart start from 0

amitchandak — Thu, 19 Jan 2023 14:39:42 GMT

eliasayyy , I doubt that is possible

Re: make my line chart start from 0

tamerj1 — Thu, 19 Jan 2023 14:54:57 GMT

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

Re: make my line chart start from 0

eliasayyy — Thu, 19 Jan 2023 23:36:15 GMT

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))