Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
BBIUser
Helper IV
Helper IV

All records are not displaying in the Shape Map & What type of Map visual best suits for this data?

Hi,

 

I am new to PBI Maps. I read through all the Microsoft articles which shows various Maps.

Now, I am prototyping using a Shape Map. Reason, I have a TopoJSON file with boundaries in it properly defined by our GIS Admin for the state, let's assume "Wisconsin" or "Illinois" .

 

Here is the sample data - which is actually a CSV file (Source) [Census Data]

 

2018-07-10_1552.png

 

1)  I need to use the colored columns in the map. 

Currently,

- Income1 is placed in Location

- County Name is placed in Legend

- Total is placed in Color saturation

2) I want to display the "TOTAL" column values (actual values as in CSV) in the shape map. How to do this?

3) I am not able to display/show all the records in the map. For example: I do not see Adams County in my Shape map. What might be the reason?

The Shape Map visual will plot up to a maximum of 1,000 data points. Is this the reason I am not able to show all the data?

4) Do I need to use some other 'Map' instead of Shape Map if the issue is because of the max 1,000 data points? If yes, which Map to use?

 

Any help is appreciated. Thanks in advance!

5 REPLIES 5
v-yulgu-msft
Employee
Employee

Hi @BBIUser,

 

1) I think you should add a Text field which can uniquely identify area to "Location" of Map, like city name, country name or state name. Otherwise, the map cannot recognise the location name you added to this section and would display nothing.

 

2) It looks like we cannot show numeric on Map visual. Maybe you could add [Total] to "Tooltip", when you hover over a specific area, it would show corresponding total value.

 

3) After dragging relative fields to Map visual, you won't see a map yet. In the Format settings pane, expand Shape, and select from the Standard Maps drop-down to show your data. At this point the rendering appears. Reference: Create Shape Map

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Greg_Deckler
Super User
Super User

Do you have more than 1,000 data points?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Thanks for the reply @Greg_Deckler. I have a total of 4500 records in the CSV.

I was about to ask this in this thread. I missed it.

 

How & where do I check how many data points are there in my map report? I am not able to tell this because I am not getting all the records in the map itself. 

 

 

Hmm, one way to do this would be to create a new Table and use SUMMARIZE function to essentially replicate how your visual is summarizing the data. Then you can just check how many rows are in your table. Note that this would be a DAX table, not a table visualization.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

I tried the SUMMARIZE function. Is this correct?

Table = SUMMARIZE(nhgis0023_ds225_20165_2016_blck_grp, nhgis0023_ds225_20165_2016_blck_grp[County Name], nhgis0023_ds225_20165_2016_blck_grp[Income1], "Total", SUM(nhgis0023_ds225_20165_2016_blck_grp[Total]))

I can see all the records when put in a table visual but not in the Shape Map. Any solution that you can think of?

My next step is checking the TopoJSON file Admin to see all the polygons are defined correctly.

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.