cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pbeeyeqs Regular Visitor
Regular Visitor

SHAPE MAP: One map with multiple fields to choose from?

I have the following data:

STATE CODE   AMOUNT A	AMOUNT B	AMOUNT C
AK	      675,350 	 366,887 	 518,517 
AK	      349,603 	 534,085 	 679,422 
AL	      636,761 	 563,821 	 670,827 
AL	      496,658 	 245,159 	 288,269 
AL	      357,326 	 337,567 	 285,557 
AR	      475,413 	 648,412 	 664,545 
OK	      383,729 	 446,712 	 333,242 

Using a SHAPE MAP, is it possible to have one map show either AMOUNT A, AMOUNT B, or AMOUNT C based on a slicer? 

 

Or, would I have to use 3 different maps with AMOUNT A for one, AMOUNT B for another, and AMOUNT C for the third map?

1 ACCEPTED SOLUTION

Accepted Solutions
v-cherch-msft Super Contributor
Super Contributor

Re: SHAPE MAP: One map with multiple fields to choose from?

Hi @pbeeyeqs 

You may use 'Unpivot columns' for Amount A,B,C columns as below.Then you may use Attribute column as slicer.

a1.png

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
v-cherch-msft Super Contributor
Super Contributor

Re: SHAPE MAP: One map with multiple fields to choose from?

Hi @pbeeyeqs 

You may use 'Unpivot columns' for Amount A,B,C columns as below.Then you may use Attribute column as slicer.

a1.png

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 263 members 2,940 guests
Please welcome our newest community members: