Why won't summarize total hours

[Anonymous]

Hi Power BI Power Users,

I am trying to sum total hours in Tutor Log_Long. Here is the screenshot of the Tutor Log Long Columns.

Abigail should have three total tutor hours. However, the graph below does not represent what I expect. There is no bar for three. Not sure what I am missing here.

The range of hours should be 0 - 7.5. However, the graph stops at 2.5. 

Could someone give me a nudge in the right direction?

Thank you

[Anonymous · Accepted solution]

I figured out the solution.

I needed a measure and a table.

Step 1.

Total Tutoring Hours = SUM('Tutorial Log_Long'[30-minute Sessions])*.5

Step 2. 

Tutor Hours by Sessions =

SUMMARIZE(

    'Tutorial Log_Long', 'Tutorial Log_Long'[Student ID], 'Tutorial Log_Long'[Sessions Weeks (groups)], "Total Tutor Hours", 'Tutorial Log_Long'[Total Tutoring Hours])

Step 3. Bring in Session Weeks (Group) into the filters

Thank you to everyone. I appreciate the nudges.

[amitchandak]

@Anonymous , Make sure Axis is categorical

[Anonymous]

Hi @amitchandak ,

Getting closer.

I made the X-axis categorical.

But I still get this output.

I would like this output. But this output uses wide data. I know there must be a step I am missing to use long data to build a graph just like this one.

My steps to make this unwanted output are as follows.

1. Transform data from wide to long (Tutor Sessions and values)

2. Group tutoring sessions

3. Calculate total hours 

Total Hours = 'Tutorial Log_Long'[30-minute Sessions]*0.5

4. Build bar chart X-axis Total Hours, Y-Axis Discount Count of Student ID

The wide data bar chart has X-axis 1st 6 weeks total hours 

1st 6 Weeks Total Hours = ('Tutorial Log'[1st 6 Weeks Total Sessions]*.5)

Y-Axis Count of Student IDs

I feel so close.

Any more nudges are greatly appreciated.

[aditya0125]

Check the formating options, something went wrong there.