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.
Hi all,
I have following table with name 'Sites'.
Now i am showing count of users in pie chart with 'SuperRegion' column. After clicking on any superregion in pie chart,the bar chart on right side shows the percentage of users by regionwise in that particular supergion as shown in below image.
Now i am showing 'percentage of Grand total' of the entire userbase,but i want show the percentage region wise not against the entire user base. I have region and employee data. Please tell me how it should be done by column or by measure or by DAX.
Thank You
Hi @Parimal_Patil,
Could you please illustrate "but i want show the percentage region wise not against the entire user base. I have region and employee data." with some examples?
Regards,
Yuliana Gu
Suppose i have Bayarea total employees-2000
employees visited website whose office is Bayarea-300
output should be-300/2000=15.00% (Employees visited website whose office is Bayarea/Bayarea total employees)
Superrigon of Bayarea is northwest(northwest may have many sub-offices like Bayarea).
So,now it is showing as employees visited website whose office is Bayarea/employees visited website where superrigon is northwest.
Hi @Parimal_Patil,
You just need to do this:
Regards.
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 |
---|---|
96 | |
95 | |
83 | |
70 | |
66 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |