Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
I figured out the solution.
I needed a measure and a table.
Step 1.
Step 2.
Thank you to everyone. I appreciate the nudges.
I figured out the solution.
I needed a measure and a table.
Step 1.
Step 2.
Thank you to everyone. I appreciate the nudges.
@Anonymous , Make sure Axis is categorical
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
Check the formating options, something went wrong there.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |