Forum Discussion
Helper IIIProbably an easy count Q
Hi Shpongle ,
It was showing as Day no, because the earlier selection in the x Axis was Day (under the heirarchy of Date).
Have changed the x axis values .Pulled the Date from the Calendar table and removed the hierarchy.
Incase you want for each date, you can change it the values of X axis to Categorical.
Hope this helps.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Super UserShpongle add measure like this, not columns
Measure Open = count(Service[SR_Service_RecID])
Measure Closed= calculate([Measure Open],Userelationship(Datetable[date], Service[date_closed]))
and use the above measures in the visual
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
- Shpongle
Thanks, parry2k - I agree that seems like it *should* work, but I got similar results: No data shows up and I observe that the left axis shows percentage!
I figure I'll share all the details in case I screwed something up.
Here are the tables and relationships:
Following is how I set up the measures:
- parry2k
Shpongle change date_entered data type to date instead of date/time and that's the issue.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
- Shpongle
Working on the weekend! Thanks for getting back to me today, parry2k - very cool.
Welllp, still no good results. I checked and they (date_opened / date_closed) were both date/time, so I changed them both to date.
The one thing that I find odd is that there is no icon to the left of the date_closed field - see the last item in the image below...
Check it out:
