Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filled map and slicer

Hi - I've a dataset (see below) that shows for each country the overall expenditure in several sector as well as the total sum. On my Power Bi page, I've a filled map shaded by the total spent (sum ...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous 

    You may select Sector 1,2...6 and then click 'Unpivot columns' as below.Then you may use Attribute column as slicer.

    Regards.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Just to give a bit more of details: I've just done these four maps using as colour saturation the individual sector or their sum. However, I would prefer having just one map and a slicer by sector. Suggestions?

:) Thank you!

  • v-cherch-msft's avatar
    v-cherch-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Anonymous 

    You may select Sector 1,2...6 and then click 'Unpivot columns' as below.Then you may use Attribute column as slicer.

    Regards.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Amazing - I didn't know this! Yes it worked but I had to create another table just with the attributes and develop the relations.

      Thanks

      Giulia