Issue with a bar chart and a legend

[Anonymous]

Hi,

I think my bar chart is broken and here is why.

I have some calculations and I want to visualise them in a bar chart. Basically it's renewers per zone and within one zone we have several sectors. That's why I put sectors as a legend. Despite the fact that data is set as sorted in descending order, it is not ordered and I get blanks where the data is supposed to be.

What is more, when I filter on "Maritime" which is blank above I get this

I don't get why this data does not show. Is it a bug? 

[_AAndrade]

Hi,

Can you share a pbix file with sample data? I could take a look at it

[Anonymous]

I tried to share it, but I get a message:

So here is the link to the drive: https://drive.google.com/file/d/14vRiWJXHMmX3eleDIqX8jZMOqk5jhsKk/view?usp=sharing 

[_AAndrade · Accepted solution]

Hi,

That's why you're having the problem:

You can read another topic about this limitation here:
https://community.fabric.microsoft.com/t5/Desktop/HELP-Stacked-Bar-Chart-with-Complicated-Legend-396...

[Anonymous]

I see, thank you!