PowerBI

[Parimal_Patil]

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

[v-yulgu-msft]

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

[Parimal_Patil]

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. 

[luxpbi]

Hi @Parimal_Patil,

You just need to do this: 

• Click on edit iteractions as shown in the picture.

• Click on you pie chart and click here on your bar chart.

Regards.