Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have two sets of data. For example:
Staff List (1000 staff)
Participation list (800 staff)
These two lists have common fields. For example:
Staff ID
Department
I want to create a 100% stacked bar chart showing participation rates by department, for example:
Finance - 80%
Operations - 100%
Audit - 99%
HR - 45%
How do I do this?
Solved! Go to Solution.
Hi, @Anonymous
According to your description and sample pictures, I can clearly understand what you want to get, I think you can achieve this using measure and clustered bar chart. You can try my steps:
This is my test data based on your sample picture:
Percentage =
var _Countofparticipation=
COUNTX(FILTER('Table',[Staff ID (Participation list)]<>BLANK()),[Staff ID (Participation list)] )
var _Countofall =
COUNTX('Table',[Staff ID (Staff list)])
return
DIVIDE(_Countofparticipation,_Countofall)
And you can get what you want.
You can download my test pbix file here
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
According to your description and sample pictures, I can clearly understand what you want to get, I think you can achieve this using measure and clustered bar chart. You can try my steps:
This is my test data based on your sample picture:
Percentage =
var _Countofparticipation=
COUNTX(FILTER('Table',[Staff ID (Participation list)]<>BLANK()),[Staff ID (Participation list)] )
var _Countofall =
COUNTX('Table',[Staff ID (Staff list)])
return
DIVIDE(_Countofparticipation,_Countofall)
And you can get what you want.
You can download my test pbix file here
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
For 100% Stacked bar chart, you would have to select Department in the Axis section and participation rates in the values.
If you don't have the participation rates already, you need to create a measure to calculate it.
The graph would look something like this:
But looking at your expected outcome, I would see you go with Stacked bar chart and change the measure as percentage if not already it is. Please refer the below:
See if it satisfies your requirement.
If you found the answer interesting, please provide a Kudos.
Mark it as solution if it helped you solve your query.
Thanks for the reply.
The confusion Im having is how do I use relationships to tie the unique staff IDs from the two datasets together.
For example:
Based on the example above, I want to get a graph showing:
How do i do this?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |