Forum

Notifications
Clear all

power bi graphiques secteurs géolocalisés partagés à 2 variables

4 Posts
2 Users
0 Reactions
74 Views
(@mante)
Posts: 3
Active Member
Topic starter
 

Hi, 

My problem           > on Excel 3DMAP we can have the pie charts proportioned and shared with 2 variables as in my file but not the region labels of the table, ( https://www.cjoint.com/c/KEwrLYphibw )

> and on POWER BI DESKTOP we can have the region labels for the exact same table but not the proportioned and shared pie charts with 2 variables. ( https://www.cjoint.com/c/KEzk6iPzSdw )

QUESTION: How on POWER BI get the geolocated, proportioned, with 2 shared variables as on EXCEL 3DMAP?

Bonjour,

Mon problème                > sur Excel 3DMAP on peut avoir les graphiques secteurs proportionnés et partagés à 2 variables comme sur mon fichier mais pas les étiquettes région de la table ( https://www.cjoint.com/c/KEwrLYphibw )

  • et sur POWER BI DESKTOP on peut avoir les étiquettes de région pour la même table exactement mais pas les graphiques secteurs proportionnés et partagés à 2 variables ( https://www.cjoint.com/c/KEzk6iPzSdw )

 

QUESTION : Comment sur POWER BI obtenir les secteurs géolocalisés, proportionnés, à 2 variables partagés comme sur EXCEL 3DMAP?

Best regards

 
Posted : 27/05/2021 4:00 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Alain,

Welcome to our forum and thanks for sharing your files.

You need to fix the data layout in Power BI to display the pie charts correctly. You should have one column for gender and another column for the count, rather than separate columns for Garcons and Filles. Then you can add the Gender field to the Legend and the count to the Size field. See file attached.

Mynda

 
Posted : 27/05/2021 11:50 pm
(@mante)
Posts: 3
Active Member
Topic starter
 

Thank you very much Mynda but I cannot open your attached file even with the latest updated version of POWER BI; Do you have an idea of the problem ? BEST REGARDS

 
Posted : 28/05/2021 6:31 am
(@mante)
Posts: 3
Active Member
Topic starter
 

Sory for the inconvenience, i manage to open the file and many thanks for changing the table, best regards.

 
Posted : 28/05/2021 6:56 am
Share: