Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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] )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Schedule a short Teams meeting to discuss your question
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Schedule a short Teams meeting to discuss your question
User | Count |
---|---|
16 | |
15 | |
14 | |
12 | |
11 |
User | Count |
---|---|
19 | |
15 | |
14 | |
11 | |
9 |