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 everyone,
I would like to make a visual in which I show the percentage of men and women in a team within in a company compared to the percentage of the company as a whole per age group.
I plan to use for this the clusterd bar chart with age in the axis, team in the legend, and number of people in the value section.
Currently if I filter on Team A I would only see team A, and if I don't filter I get a bar for all the teams within the company.
What do I need for this type of graph? A dax measure, grouping ?
Can you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data? Like this (just copy and paste into the post window).
Column1 | Column2 |
A | 1 |
B | 2.5 |
User | Count |
---|---|
57 | |
46 | |
19 | |
16 | |
15 |
User | Count |
---|---|
116 | |
41 | |
40 | |
28 | |
22 |