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
Anonymous
Not applicable

Displaying Map data

Hi, 

I am new to Power BI and need help to resolve this task.

 I have a map that displays that shows the number of medical tests per country. We are looking at just two types of tests-

commercialised and in development. 

The task is whenever a country is selected, I need to display on two different cards the count of each test per country.  E.g. If US has 235 commercialised tests and 60 Indevelopment tests, Then the cards should display 235 and 60 at the same time. 

 

Currently when a country is selected, it displays only the count of one test at a time - as shown in the screen shot below. 

Capture1.PNG

The screnshot below is the desired result.  Both cards display data.

Capture2.PNGThe data is stored as shown below.

Development StatusCountry
CommercialisedUS
In developmentKorea
Commercialised

China

 

CommercialisedChina
In developmentUS
  
  

 

Any suggestions on how to solve this?

 

Thanks in advance,

 

Phyllis N

 

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

I think it's only possible if you hold the CTRL key and click on both the "slices" of a piechart. Or create a normal filter for the country (and don't use the map as a filter) 

Jef_0-1594213608607.png

 

View solution in original post

Anonymous
Not applicable

Hi Jeff

Thanks a lot for your response. It worked. This inspired me to create a new filter for the tests - and users can select multiple tests at the same time too.

View solution in original post

3 REPLIES 3
dax
Community Support
Community Support

Hi @Anonymous , 

I am not clear about your requirement, if possible could you please inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

I think it's only possible if you hold the CTRL key and click on both the "slices" of a piechart. Or create a normal filter for the country (and don't use the map as a filter) 

Jef_0-1594213608607.png

 

Anonymous
Not applicable

Hi Jeff

Thanks a lot for your response. It worked. This inspired me to create a new filter for the tests - and users can select multiple tests at the same time too.

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.