Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Pierre-Antoine D]

Hello all 🙂

As I am new to Power BI, I try to complete a simple shape map.

I have loaded in my rapport the results of the last French elections and I’d like to color each region with the color of the winner (party = CodeNuance).

I can easily display the maximum of votes (Max Voix) on the tooltips, but I can’t succeed in making the link to get the good color on the map.

For example, the region “Ile-de-France” has a maximum of votes (1158851) from the party “NUP” and should be red ;
                      the region “Haut-de-France” has a maximum of votes (545237) from the party “RN” and should be purple

Thank you so much for your help !

——————————
Pierre-Antoine D
Engineer
——————————

[Pierre-Antoine D]

Hello everyone 🙂

Yesterday, I eventually managed to color the shape map with the good color by creating a measure “Couleur Max Region”

But the thing is Power BI gives an error when I choose some columns with the stacked bar or using the slicer. For example choosing “NUP” or “ECO” gives me :

“a table with multiple values was supplied where a single value was expected“

I guess it has to do with the blank cells but I struggle to fix it…

Could you help me ?

Cheers

——————————
Pierre-Antoine D
Engineer
——————————
——————————————-

[Pierre-Antoine D]

Hello,

Can anyone help please ?

——————————
Pierre-Antoine D
Engineer
——————————
——————————————-