Retrieve Analytics Value from a Visual

[NNaj]

Hi All,

I have a clustered column chart showing some values and I have used the analytics tab to add an average line.

Is it possible to retrieve the value of the average to use in other places or to display this value as a card or in a table?

I want to use these values of 0.34, 0.17.. etc for some conditional formatting on the table.

I cant find the average as a separate function because these are measures and I can't input measures into he AVERAGE function. This is why I am trying to retrieve these values.

Thank you

Nad

[amitchandak]

Is analytics icon not allowing you the option to add lines

https://community.powerbi.com/t5/Desktop/How-to-add-average-line-to-measure-bar-chart/td-p/326940

https://geekdecoders.blogspot.com/2019/02/how-to-insert-average-line-in-power-bi.html

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[NNaj]

The lines shown in the image have been added using the analytics of the visual. I need to use these values for other calculations. Is there a way to reference these values in my calculations?

[powerbi_david27]

I am having the same issue here - did you find any way to solve this ?