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)

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

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's avatar
Shpongle
Icon for Helper III rankHelper III
6 years ago

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's avatar
    Shpongle
    Icon for Helper III rankHelper III
    6 years ago

    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

    • 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)