Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Dazzling DAX users,
I have a conundrum. I can't make the following visuals using calculated measures. - Line Chart, Bar Chart, etc. I am limited to a table.
Here are my calculated measures.
But I can't make the aforementioned visuals with a calculated measure.
Can only place Tutoring in HH:MM into Tooltips.
Should I use a calculated columns for Total Tutoring Hours and Tutoring in HH:MM?
My goal is to build visual that demonstrate total tutoring hours:minutes by student by day.
Any nudge is greatly appreciated.
Hi @FreemanZ - thank you for the nudge.
I thought that by pulling in Total Tutoring Hours that i summed.
But i have to sum in hour in the calculated measure of Tutoring Hours in HH:MM.
Am i understanding you correctly?
hi @Anonymous
FORMAT returns text, instead of numeric values, so totaling text doesnt work.
Try to sum in hour or minute and in the last step format to HHMMSS if needed for each measure.
User | Count |
---|---|
47 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |