Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Having issues showing all the data in the Stack Column chart when using the Legend feature.
Here's the view with no Legend. It's a count of deals by week:
Stacked Column Chart No Legend (Note Max value)
I have a column with Reseller names associated with these deals. I added it to the Legend and get below. The columns are shorter than without the legend, so I'm missing data:
Stacked Column Chart, Adding Reseller column in Legend (Note max is less)
I have a column to filter between ADR/DMP (DMP are all the Reseller names that begin with a-, there are thousands of distinct "a-" values, though in any given week, there aren't that many to display, there are only a few hundred ADR names (no a-)). This view I filter for ADR and see a subset, with peak around 20ish.
Filtering on ADR (different view)
Next if I filter on DMP, I get the original view with no filter. The peak column is 10.
Filtering on DMP (same as no filter)
I suspect there's a legend buffer limitation, and the thousands of a- names (DMP) overflow the buffer so no ADR names get shown in the non-filtered view (as they start after the a- names alphabetically), so I'm not seeing all the data.
So is this a bug or am I doing something wrong?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.