Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
For example on employee table, I need to show the number of employees in each department as well as total employees in a single visual.
I am able to do it in different visuals and keep side by side. Just checking if there is any possibility to keep them in a single visual.
Thanks
KVB
Solved! Go to Solution.
Hi @vkomarag,
You can create two measure using the formula.
Department = COUNTA(Table1[Employee]) Total = CALCULATE ( COUNTA ( Table1[Employee] ), ALL (Table1 ) )
And select them as value field in bar chart. Please see the following screenshot, I use Cluster column chart, if you want to other bar chart, you can change it.
Thanks,
Angelia
Hi @vkomarag,
After test using the solution @dkay84_PowerBI posted using the following sample table.
Then you get expected result.
If you still have problem, please share your sample data for further analysis.
Best Regards,
Angelia
Actually I need it in a bar chart in vertical representation.
Hi @vkomarag,
You can create two measure using the formula.
Department = COUNTA(Table1[Employee]) Total = CALCULATE ( COUNTA ( Table1[Employee] ), ALL (Table1 ) )
And select them as value field in bar chart. Please see the following screenshot, I use Cluster column chart, if you want to other bar chart, you can change it.
Thanks,
Angelia
Hi there,
You should be able to create a measure that concatenates two values. One for the total count of that column, and one for the count of rows of that department. It could look something like this:
Count of Employees
=COUNTA(Table[EmployeeID])
Count of ALL Employees
= CALCULATE ( COUNTA ( Table[EmployeeID] ), ALL ( Table ) )
Concatenated Values
=
[Count of Employees] & " / " & [Count of ALL Employees]
You can this use this on a single card style or other visual. Hope this helps!
You can also use Tooltips to display the total on hover, where the actual components of the visual (i.e. columns or bars) show the value per department. Lastly, you can use a stacked column with department as legend to visually show the total (height of column) and breakdown by department (colors).
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 |
---|---|
109 | |
102 | |
84 | |
79 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |