cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
i820017
Resolver II
Resolver II

Charting Issues with Decimal Minutes

Hey Everybody,

I am trying to graph an average for a column entitled TalkTimeAvg__Column vs CallMonth as a line graph, and it is graphing an overall total instead of an average.

 

Here is the formula for the TalkTimeAvg__Column

TalkTimeAvg__Column = DIVIDE([TalkTime_Sum], [ACDAnswer_Sum], BLANK()) / 60
 
Here is a snapshot of the TalkTimeAvg__Column
i820017_1-1622233587021.png

 

 
 
For 'Axis', I put in 'CallMonth'....For 'Values', I put in 'TalkTimeAvg__Column' to create the line graph
 
Here is a snapshot of the graph that I am getting.
i820017_0-1622233442312.png

 

 

The issue is that the Y-Axis should be showing an average between 1 and 10 for all of the employees for each month. Instead it is showing a sum.

 

Does anyone know how to fix this?

 

Thanks

Dan

1 ACCEPTED SOLUTION

I just used a measure instead of a calculated column, and the Y-Axis is still an overall sum instead of a number between 1 and 10.

View solution in original post

5 REPLIES 5
v-shex-msft
Community Support
Community Support

Hi @i820017,

Can you please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

I changed the calculated column to a measure, and it worked.

i820017_0-1622558535150.png

 

Ashish_Mathur
Super User
Super User

Hi,

I think you are getting confused between calculated column and measure.  Share the link from where i can download your PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

I just used a measure instead of a calculated column, and the Y-Axis is still an overall sum instead of a number between 1 and 10.

I just re-did my measure, and it works now...thanks!!

i820017_0-1622558410271.png

 

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Kudoed Authors