Power BI Exchange

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
------------------------------

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
------------------------------

Original Message:
Sent: Jun 27, 2022 04:04 PM
From: Pierre-Antoine D
Subject: color a shape map

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
------------------------------

Hello,

Can anyone help please ?

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

Original Message:
Sent: Jun 29, 2022 08:54 AM
From: Pierre-Antoine D
Subject: color a shape map

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

Original Message:
Sent: Jun 27, 2022 04:04 PM
From: Pierre-Antoine D
Subject: color a shape map

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
------------------------------