Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I have a plot as follows:
In this plot, I have a measure for the Avg 2021 and Avg 2022 lines shown
:
I want one line that shows the average value of the year being plotted. I have tried multiple measures but none of them produce this result.
Any help anyone can offer would be greatly appreciated.
Hi @CL7777 , can you send me a screenshot with the relationships of the dates, and what date are you using for the chart?. Thanks
Hi @CL7777 , try this measure
Average = CALCULATE(AVERAGE('Table'[Import]),ALLEXCEPT('Table','Table'[Date].[Year]))
The result:
Best regards
Thanks for your reponse @Bifinity_75. The plot that shows the bar chart is actually a measure and when I use the same idea as you had above but put averagex([measure]) instead, O get an incorrect result. the measure is:
any ideas why this might be wrong? thank you so much