How to bring all distinct values of a column in stacked bar chart

[nj17]

Hi all,

I need to bring below values N/A, no ,yes of a column in to a stacked bar chart.

           

Kindly help.Do I need to create measures for each distinct values?

[v-yalanwu-msft · Accepted solution]

Hi, @nj17 ;

I made a simple sample and you could set distinct count in "N/A,yes,no"  field.

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu]

@nj17 

could you pls provide some sample data?

[amitchandak]

@nj17 , Create a measure with the distinct count of a column that you want and use this column as a legend

distinctcount(Table[Value])

[nj17]

Can you please help me why its showing me same count and % in chart.

I have used column in legend and measure in value

[nj17]

Thank You @amitchandak 

Also if I have 10 columns and I created 10 measures then how can I show all of them as below in a single visual

[amitchandak]

@nj17 , You can have multiple columns or legends not both

You have clustered stacked visual if needed

https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200001934?tab=overview