Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I finally learned how make new measures. I made the 'Audit Finding %' measure a column. Now I want to make a line and clustered chart showing them in a graph with the AVG as the lines and values as bars. But I couldnt make it to wrk. I cannot use that same measure to make an AVG measure. Dragging the Audit Finding % in the Y-Line field does not allow me to change it to an AVG.
HI,
I am not sure how your datamodel looks like, but please try something like below if it suits your requirement.
average line chart measure: =
AVERAGEX ( ALL ( tablename[Team Member] ), [Audit Finding % measure] )
Its still not showing. The 'Audit Finding % measure' is not an actual column but is just a measure. Maybe that's why.
Is there a workaround?
Hi,
Please share your sample pbix file's link.
Thank you.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
26 | |
10 | |
10 | |
9 | |
6 |