Forum Discussion
Power BI Visualisation - stacked bar chart with 2 values
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,
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
3 Replies
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
You can find more on Quick Measures in Power BI documentation: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-quick-measures/.
Thanks for your help Anonymous :)
