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

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's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

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!