cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
allenoneill Frequent Visitor
Frequent Visitor

How to show summary values in map region?

Hi all,

 

I am trying to put aggregate values into a map in pretty much the same way as shown in the attached image...

 

I'm going around in circles trying to figure it out and would appreciate input from you experienced folk!

 

Stuff that I have available as input

 

* Irish County name  (also have lat/long available but reckon I don't need these as I am aggregating up to county level)

* Categories  (Rugby, Football, Athletics)

* Category values

 

example:

 

County

Rugby

Football

Athletics

Total

Dublin

100

50

25

175

Cork

50

80

10

140

Galway

70

120

30

220

 

I have tried pivoting it like this:

  

County

Category

Value

Dublin

Rugby

50

Dublin

Football

80

Dublin

Athletics

120

Cork

Rugby

50

Cork

Football

80

Cork

Athletics

10

Galway

Rugby

70

Galway

Football

120

Galway

Athletics

30

 

That seemed to get me further, but not quite right .... 

 

As per the attached image, I am trying to have a pie-chart appear in the county, that shows slices for each category value (or percentage)

 

Any assistance most gratefully received!

 

Allen.

 

PieValuesInState.pngMap regions showing category values/percentage in pie-chart

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: How to show summary values in map region?

@allenoneill,

 

You may drag measure below to Tooltips.

Measure =
CALCULATE ( SUM ( Table1[Value] ), ALLSELECTED ( Table1[Category] ) )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: How to show summary values in map region?

@allenoneill,

 

You may drag measure below to Tooltips.

Measure =
CALCULATE ( SUM ( Table1[Value] ), ALLSELECTED ( Table1[Category] ) )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.