Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
nj17
Helper III
Helper III

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

Hi all,

 

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

nj17_0-1629699312665.png         nj17_1-1629699362997.png  

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

1 ACCEPTED SOLUTION
v-yalanwu-msft
Community Support
Community Support

Hi, @nj17 ;

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

vyalanwumsft_0-1629860265538.png

The final output is shown below:

vyalanwumsft_2-1629860435420.png

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.

View solution in original post

6 REPLIES 6
v-yalanwu-msft
Community Support
Community Support

Hi, @nj17 ;

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

vyalanwumsft_0-1629860265538.png

The final output is shown below:

vyalanwumsft_2-1629860435420.png

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
Super User
Super User

@nj17 

could you pls provide some sample data?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




amitchandak
Super User
Super User

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

 

distinctcount(Table[Value])

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_0-1629710071938.png

 

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

 

nj17_0-1629701698282.png

 

 

@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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.