how to create a linear line in line chart
Hello everyone, I have built a cumulative line in line visual and I want to create a linear line that will show 0 at the start and max Value at the end of the visual. Any tips ? I literally need the black line to be built. I am using dax so all measures are explicit but I cant figure out how to make this basic line :D. I have tried this Linear line = var minvalue = 0 var maxvalue = [Nr. WO] var startdate = [FirstDateWP] var maxdate = [LastDateWP] return IF(CALCULATE( MIN(DateTable[Date])) <= startdate,0, IF(CALCULATE(MAX(DateTable[Date])) <= maxdate,maxvalue, BLANK())) this is the result but I need this
