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.
I would like to add an average line to my visualization. The issue I'm running into is this average can be variable depending on the client selected. How do I get the line to change for each client automatically rather than having a measure that would need to be manually changed?
Solved! Go to Solution.
Hi @Anonymous,
You can click on analytics panel to add average line based amount column, it will dynamic changes based on current item.
Notice: average line only show summary average value based on selected column, it not affect by current group and can't generate multiple average lines based on category column.
Regards,
Xiaoxin Sheng
Hi @Anonymous,
You can click on analytics panel to add average line based amount column, it will dynamic changes based on current item.
Notice: average line only show summary average value based on selected column, it not affect by current group and can't generate multiple average lines based on category column.
Regards,
Xiaoxin Sheng
Hi @v-shex-msft - I played around with the data and visualizations some more and was able to accomplish what you suggested as the solution. Thanks!
Hi @v-shex-msft - I'm needing to accomplish what I want to do in a Line and Clustered Column chart as I have a count on the left Y-axis and aging of those counts on the right Y-axis. I'm wanting to do the average of the aging on the right Y-axis to show which item's aging are falling above or below the average line. It seems in order to do what you showed is using a Clustered Column chart which ends up eliminating one of the data points. If there is a better visualization that could be used to accomplish this, I'm open to changing it. Thanks for the help.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |