Power BI Visualisation - stacked bar chart with 2 values

[PowerBI-Curious]

Hi

I have a column graph which is currently split into 4 columns by hierarchy. What I would like to have is each of these columns to show the proportion of yes or no within that. Example of data typed below: 

Hierarchy	Yes/No
Admin	Yes
Engineering	No
Elimination	Yes
Admin	Yes
Engineering	No
Elimination	No
Admin	Yes
Admin	No

Any help appreciated.

Thank you,

[Anonymous]

You can find more on Quick Measures in Power BI documentation: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-quick-measures/.

[PowerBI-Curious]

Thanks for your help @Anonymous 🙂

[Anonymous · Accepted solution]

Hi,

I think you may look for something like this:

Proposed result.

If you need it in a table visual, use Quick Measures - Filtered value. Example (to count the number of Yes):

Quick Measure.

If your goal is just to visualize the ratio, use 100% Stacked bar chart as I did in the first screenshot above.

Hope that helps.

Cheers,

Pawel