Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

bar bart not displaying as expected

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.

Need Help
Show and Tell

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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.
       
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

     

     

    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.