Forum Discussion

creedrulz's avatar
creedrulz
Frequent Visitor
4 years ago

Stack Bar chart not showing some values

Hi All,

 

I'm not sure what's going on because my tack bar chart is omitting some data even though everything is displayed when the visual is converted to a table. Could someone maybe clarify what's happening on and how to resolve this problem?

Thanks,

 

Deevs

Need Help
Show and Tell

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    creedrulz interesting and thanks for providing the further details. Not sure what to say without looking at it. I can try to reproduce at my end, anyhow, report this as an issue, maybe it is a bug.

     

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

     

    Learn about conditional formatting at Microsoft Reactor

    My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    creedrulz do you have conditional formatting which maybe using the color which is not visible?

     

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

     

    Learn about conditional formatting at Microsoft Reactor

    My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

    • creedrulz's avatar
      creedrulz
      Frequent Visitor
      4 years ago

      parry2k 

      On the visual, I don't have any conditional formatting. However, because there are over 50 departments (i.e. used as legend).It fixed itself when I used a filter to limit the top 100 users, but I assumed that sorting ascending by values should not omit or leave bank random data points, which is strange. However, by restricting it to the top 100 users, there were free users who were not showing any bars despite the fact that there was data.

       

      Thanks,

      Deevs

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi creedrulz ,

         

        How do you get the values in [mEventsCount], by measure or count? Did you add any filter in your bar chart?

        Please share a sample file without sensitive data with us and show us a screenshot with the result you want.

        This will make us easier to solve your problem.

         

        Best Regards,
        Rico Zhou

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.