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
apaulso9
Resolver I
Resolver I

Percentage of Category displayed on Bar graph.

Hello,

 

I would like to create a graph like this:

percentage.PNG

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.

exmaple.PNG

 

Any ideas would be lovely.

 

Here is some example data:

 

IDIn 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
3NoYes33-47-9NoMore than $25,000
4NoYes45 or moreNoneNoMore than $25,000
5NoYes5 or moreNoneAlmost everydayNoMore than $25,000
6NoYes32-3NoneNoMore than $25,000
7NoYes12-3NoneNoMore than $25,000
8NoYes21-2NoneNoMore than $25,000
9NoYes2None1-2NoLess than $25,000
10NoYes35 or more3-5NoLess than $25,000
11NoYes35 or moreNoneNoLess than $25,000
12NoYes35 or moreNoneNoLess than $25,000
        
1 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. 

View solution in original post

6 REPLIES 6
geichenbaum
New Member

where can i see the solution you post?

 

ryan_mayu
Super User
Super User

have you tried to use DAX to acheive that? 

could you pls provide the sample data ?





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

Proud to be a Super User!




@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.

 

@apaulso9 

pls see if this is what you want





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

Proud to be a Super User!




could you pls provide some sample data?





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

Proud to be a Super User!




@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. 

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.