Forum Discussion
Adding a Constant Line Pulls Historic Data But It's Blank
Hi ME_1976,
If you go to the options of the chart one of the last options is reference line, there you add a new line as a constant, use your measure on that and everything should work
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane
Hi ME_1976 ,
How are you setting up the flat line? is it a measure? Can you share the syntax please.
I just added a new measure using 'constant line = 10' then added it to Line y-axis.
Hi ME_1976 ,
I did some tests on my side and adding a measure on the chart it works correctly and nothing is added.
How are the other two metrics calculated? I believe that you cam have a filter context transition that is not getting picked up by this new measure.
Is the calendar table related with your fact table?
Hi, I'm not 100% sure what you mean (still getting to grips with Power Bi and the technical wording). The date range is within a slicer, with the dates running continuously for each end of month and forms part of the data. If that makes sense. I'm mindful of the data within the document, so I've attached screen grabs of the settings to see if that helps answer the question.
Hi ME_1976,
If you go to the options of the chart one of the last options is reference line, there you add a new line as a constant, use your measure on that and everything should work
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane