Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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.