Forum Discussion

Shpongle's avatar
Shpongle
Icon for Helper III rankHelper III
6 years ago
Solved

Probably an easy count Q

Hi guys,   If I spend over an hour trying to figure something out, I just post it here for the pros to figure out!   This seems relatively simple, and I have done this before on a different PBIX ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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)

     

Shpongle's avatar
Shpongle
Icon for Helper III rankHelper III
6 years ago

Hi - I'm starting to think this thread got a little too long for anyone to take an interest! If you read only the post that is two posts above this one, it will boil it down, and it has a link to the file.

 

I'm hoping someone can help out - I'm feeling pretty burt out on this one but need to make it work

 

Thanks!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Shpongle ,

 

I think there is some issue with the model or file. 

I copied your table in an excel sheet and imported it again and i am getting the values.

 

 

 

 

 

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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)

     

  • Shpongle's avatar
    Shpongle
    Icon for Helper III rankHelper III
    6 years ago

    AT LONG LAST!!! It's working! I feel like a goof for not being able to figure it out and I'm still going to need a minute to review why it's working but.... IT WORKS!

     

    I'm not sure why my date table didn't work but yours did. I think my date table might need a little review. Once I switched it over to your calendar, *boom*. 

     

    I spent an embarrasing amount of time on this, and so I am very grateful to you, Anonymous, for taking the time to help!

     

    Kind Regards,

     

    Mitch

  • Shpongle's avatar
    Shpongle
    Icon for Helper III rankHelper III
    6 years ago

    Hi Harsh,

     

    I appreciate the effort here - The only problem is that the chart is showing the total number of tickets as opened and closed for each day! The other weird thing is that it's not showing the date along the bottom, just a day number.