Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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?
I am having the same issue here - did you find any way to solve this ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |