Stacked bar chart with many legends

[Anonymous]

( I'm not good at English. This is machine translation. I'm sorry. )

I want to create a stacked bar chart with many legends. However, the total value will be short.
It is accurate in the table chart.

Who knows the solution?

[AiolosZhao]

Hi @Anonymous ,

Could you please give a some small sample to show your problem?

Thanks.

I'm not sure where you are from, if Japanese is better, please see below.

小さな例があればもっと良いでしょう

Aiolos Zhao 

[Anonymous]

Thank you for your reply!

（Thank you for adding Japanese examples）

It turned out that there is no solution for this matter.

https://docs.microsoft.com/en-us/power-bi/desktop-high-density-sampling

PowerBI has a limit of 60 legends.
I would like to consider an alternative.

[AiolosZhao]

Hi @Anonymous ,

To be honest, I still didn't get your point.

Do you mean, for example,

In table, column A + column B = 100, but after you change the table to stacked bar chart, column A + column B = 90?

do you have any duplicate value in column A or B?

are measures and dimensions of these two charts same?

わたしは 日本語が 少し わかりますから、日本語で いいです。

Aiolos Zhao

[Anonymous]

@AiolosZhao 、ありがとうございます。

>In table, column A + column B = 100, but after you change the table to stacked bar chart, column A + column B = 90?

ご認識のとおりです、例として画像を添付します。

[AiolosZhao · Accepted solution]

Hi @Anonymous ,

OK, I got your point.

Because it seems that power bi have the limitation for the stacked column chart, so if you have too many legends, it will only show part of them.

I think it's better to change a chart type to show your data,

or group by your data then show it in your chart.

Thanks.

Aiolos Zhao

[Anonymous]

Thank you @AiolosZhao 
It was very helpful!

[AiolosZhao]

I'm glad to help you~ @Anonymous 

どういたしまして

Aiolos Zhao