cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TMO_KY
Helper I
Helper I

Trouble with Dynamic Reference Line from Average Total (measure)

I'm trying to create a dynamic reference line based off a measure I created (AVG OT).  When I add the measure to a card, I get what I am looking for and it changes when I use my filters.  That part is working good.  Now the issue I have is when I add that AVG measure to a bar chart by employee names, it takes the employees avg and creates a line that coincides with each employee.  I want it to stay as the total value instead of each individual's value.  Here are some pictures:

 

Current:

TMO_KY_1-1593442258825.png

 

Is there a way to get the Reference line to only show the Total, in this example = 11.29?  Instead of changing the values based on employee?  Thanks in advance.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@TMO_KY , create a measure like this

 

Avg OT = calculate([Avg OT per period], all(Table))

And use. 

 

Or use analytics pane

https://docs.microsoft.com/en-us/power-bi/desktop-analytics-pane

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@TMO_KY , create a measure like this

 

Avg OT = calculate([Avg OT per period], all(Table))

And use. 

 

Or use analytics pane

https://docs.microsoft.com/en-us/power-bi/desktop-analytics-pane

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

View solution in original post

@amitchandak I tried almost everything but that worked!  Thank you!!

Helpful resources

Announcements
Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Power BI Womens Summit 2021 768 x460.jpg

Interviews, learning sessions, allies, and more!

#PowerBIWomenSummit

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!