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 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!
Helper IIIWorking 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:
- parry2k
Shpongle that's fine because you had the relationship on that column, not sure why it is not working, I would recommend to share pbix file with sample data and remove any sensitive information before sharing.
- Shpongle
Hi - I have probably spent five more hours trying to self service on this one... just... because... I thought I could figure it out!!!
A quick refresh: I'm just trying to create a stacked column chart that shows the number of tickets opened vs the number of tickets closed by day. The only visual that I have set up on this shared pbix is trying to accomplish this but it shows a percentage instead of a count on the left axis, and it doesn't show any ticket counts!
The following is close enough to what I want to serve as an example - if we can get it here then I can take it the rest of the way:
Here is what I get:
THANK YOU for offering to help out, parry2k (or anybody else who has a suggestion!)
- Shpongle
Hi all, I spent a little more time on this over the weekend but I'm stumped! I'm wondering if the .pbix file has been compromised! I genuinely cannot figure out why I can't create this simple view.
Link to the pbix in the post above if anybody wants to take a shot at it.
Thanks