Stack Bar chart not showing some values

creedrulz · ‎01-09-2022

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

parry2k · ‎01-09-2022

@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.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

parry2k · ‎01-09-2022

@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.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

creedrulz · ‎01-09-2022

@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 · ‎01-11-2022

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.