Forum Discussion
Adding Measure extends X-Axis...
your data model is the wrong way round.
Dates should be the dimension table and "Table1" the facts table.
Then do what Ashish_Mathur suggested.
Why is the dark line supposed to be straight? It's an average over 30 days.
By the way, you can do that much simpler with Window functions.
30DayAvg = CALCULATE(AVERAGE(Table1[Reading]), WINDOW(-29,REL,0,rel,ALLSELECTED(Dates[Date])))PBI file attached.
https://www.icloud.com/iclouddrive/005zx52OtE6uGPWPbm07jWGLA#x_axis_issue
Attached. Understand that it's not always easy to upload files for those of us who work in corproate environments where everything is locked down. I thought it was straightforward enough to understand from a screenshot, but realize that a PBIX is always better when asking for help.
Thanks for looking.
your data model is the wrong way round.
Dates should be the dimension table and "Table1" the facts table.
Then do what Ashish_Mathur suggested.
Why is the dark line supposed to be straight? It's an average over 30 days.
By the way, you can do that much simpler with Window functions.
30DayAvg = CALCULATE(AVERAGE(Table1[Reading]), WINDOW(-29,REL,0,rel,ALLSELECTED(Dates[Date])))