Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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,
Solved! Go to Solution.
Hi,
I think you may look for something like this:
If you need it in a table visual, use Quick Measures - Filtered value. Example (to count the number of Yes):
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 🙂
Hi,
I think you may look for something like this:
If you need it in a table visual, use Quick Measures - Filtered value. Example (to count the number of Yes):
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |