Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.