Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
The screnshot below is the desired result. Both cards display data.
The data is stored as shown below.
Development Status | Country |
Commercialised | US |
In development | Korea |
Commercialised | China
|
Commercialised | China |
In development | US |
Any suggestions on how to solve this?
Thanks in advance,
Phyllis N
Solved! Go to Solution.
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)
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.
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.
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)
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.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |