Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
66 | |
62 | |
62 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |