Forum Discussion
Static Trend Line for Column Chart
Hi Anonymous ,
Is the gif similar to your expected output?
You can create a new date table from your fact table:
Date = values(fact[date])Then use the new date column as slicer for you to select date range you want. And then you can use the following measure as average lines
Wkly Avg = CALCULATE(DIVIDE(Total POs, ISO Wk Count, 0 ),TREATAS(VALUES('Date'[date]),'fact'[date]))You can refer to the sample pbix file.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Anonymous if you want to have a average trend line in your chart that you can have easily from analytics tab -> average line. This will use your chart data and according to the time period selected will change
in case you wish to achieve anything else, please write back. thanks
negi007 thanks for the response, unfortunately average lines are not available in the analytics pane for the combo charts. So I am looking to create it as a measure so that I can get the result that you are showing above.
Hi Anonymous ,
Is the gif similar to your expected output?
You can create a new date table from your fact table:
Date = values(fact[date])Then use the new date column as slicer for you to select date range you want. And then you can use the following measure as average lines
Wkly Avg = CALCULATE(DIVIDE(Total POs, ISO Wk Count, 0 ),TREATAS(VALUES('Date'[date]),'fact'[date]))You can refer to the sample pbix file.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai