Percentage of Category displayed on Bar graph.

[Anonymous]

Hello,

I would like to create a graph like this:

The percentage is the precent "yes" from the seperate categories.

However, on power BI I can only show the percent of grand total or count. For example I only want the "yes" area on this bar chart shown AND it must maintatin the same percentage.

Any ideas would be lovely.

Here is some example data:

ID	In the last 12 months, was there something that prevented you from getting the medical care you needed?	Does every member in your household currently have health insurance?	On an average day, how many servings of fruit and vegetables do you eat?	On average, how many days per week do you exercise 30 minutes or more?	In the last two weeks, how many days have you felt sad or depressed?	In the last two weeks, how many days have you felt sad or depressed?	Income
3	No	Yes	3	3-4	7-9	No	More than $25,000
4	No	Yes	4	5 or more	None	No	More than $25,000
5	No	Yes	5 or more	None	Almost everyday	No	More than $25,000
6	No	Yes	3	2-3	None	No	More than $25,000
7	No	Yes	1	2-3	None	No	More than $25,000
8	No	Yes	2	1-2	None	No	More than $25,000
9	No	Yes	2	None	1-2	No	Less than $25,000
10	No	Yes	3	5 or more	3-5	No	Less than $25,000
11	No	Yes	3	5 or more	None	No	Less than $25,000
12	No	Yes	3	5 or more	None	No	Less than $25,000

[geichenbaum]

where can i see the solution you post?

[ryan_mayu]

have you tried to use DAX to acheive that? 

could you pls provide the sample data ?

[Anonymous]

@ryan_mayu I have yet to try DAX because I am not sure how to show a measure in this way. I will add example data to the originalpost! Sorry for forgetting to do that. I am looking for the precent of "More than $25,000" and "Less than $25,000". Thank you.

[ryan_mayu]

@Anonymous 

pls see if this is what you want

[ryan_mayu]

could you pls provide some sample data?

[Anonymous · Accepted solution]

@ryan_mayu I added a table to the original post! I figure it out though. I manipulated the ledgend a bit and made a measure.