bar bart not displaying as expected

[Anonymous]

Hello Power BI Power Users,

I have what seems to me like a simple problem.

X-Axis : Hours 0 - 7.5 in decimal form. There are some hours in .5 increments

Y-Axis: Count of Students...I use Student IDs

Filtered by 1st six weeks sessions

DAX used: 

Tutor Time in Hours = ROUND(SUM('Tutorial Log_Long'[30-minute Sessions]) *.5,1)

Columns Used:

Student ID: ID for every student

Grouped Six week sessions: Grouped sessions to creat 1st six weeks, 2nd six weeks, 3rd six weeks

Here is my ouptut

 In the matrix below, I would like to create a bar chart that shows x-axis: first six weeks sessions hours 0 -7.5 and count of student IDs in Y-axis.

For example: 4 students at 7.5 hours, 6 students at 7 hours, etc.

Any nudge is greatly appreciated.

[Anonymous]

I think I found something that will help.

This table made me realize what I want.

For example, for this student , I would like to aggregate three hours of tutoring. However, the bar graph will max out for this student at 1 hour.

I think my aggregation is wrong. 

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

I need the nudge in the calculated table.

Appreciate any nudge.

[amitchandak]

@Anonymous , you can only add sparklines as of now

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-sparklines-tables

[Anonymous]

Hi @amitchandak ,

Thank you for your reply.

Here is a little more context I neglected in my original post. 

I can make the expected bar chart using wide data.

However, when I use long data, I do not achieve the same visual.

I've gotten closer by creating a calculated column. 

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

Maybe my question should be, am I using the correct calculated measure or column?

I would like to display the total hours in decimal form.

I would like to use long data because I use it in the rest of my dashboard. 

Let me know if what I am saying makes any sense.

Appreciate the nudge.