power bi stacked bar chart issue when 0 value

[Arnault_]

Hi All,

I have an issue with the stacked bar visual.

When I create a table with several measures the values appears like expected (the different measures are added to"Values" category).

When I simply copy and paste the table and transform it into a stacked bar chart some values do not appear. It seems when one of the measure has a zero value, the following measures are not displayed.

If you looked at the following figure, the different measures are S01, S02, S03...

All the measures are properly displayed in the table, but only S01, S02, S03 and S04 are displayed in the bar chart.

I don't mind that S05 is not displayed since it is equal to zero, but why do S06, S07 ... couldn't be displayed? Is there a way to fix that?

[amitchandak]

@Arnault_ , As long as you are able to drag the measure it should display. Can you share sample  after removing sensitive data.

[Greg_Deckler]

@Arnault_ - Not sure why those would not show up, can you share the PBIX?

[Arnault_]

Hi @Greg_Deckler @amitchandak 

Thank you for your reply. Sharing my pbix is possible but it is quite a big file (80mo).

I am pretty sure it is some kind of memory issue because if I move the measures up and down (in the visual settings, in "Values"), some values appear like magic. I can't figure this out and as you say, the table displays the values as expected, why the bar chart would not.

I will try to prepare a sample and share it with you.

Thanks a lot.

[Arnault_]

Hi @Greg_Deckler  @amitchandak ,

I finally found the solution by recreating the visual from scratch and compared the default settings with my current visual. It seems, I originally defined the axis boundaries which of course has an impact on how the data could be displayed. In my example, the upper boundary was defined at 200 while the sum of my measures could be higher (400 in my example). Then of course, the visual could not display all the measures above the limit I defined.

Sorry for having bothered you my stupid question.

Cheers

[Greg_Deckler]

@Arnault_ - No worries, I was kind of mystified as to what was going on so glad you explained it!! 🙂