The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi
I have a list client data, amongst which there is information about the country they come from.
I have a qualitative variable (say delivered / not delivered)
I want to create a map-graph with the countries being for example green if more than 70% is delivered.
I am not good in DAX.
I thought of creating a matrix, calculating the values for each country. At this point, i want to use the matrix data to either create a new dataset or directly use them for a graph.
Is there any way?
thanks
We can't stress this enough. Pleae provide a sample data. 🙂
Proud to be a Super User!
Hi
Thanks for replying,
THe first columns of my dataset are like below:
SUB REGION CODE | Country | Client | identified | status |
GEO0069 | Germany | A | 1 | Delivered |
GEO0069 | Germany | B | 5 | Delivered |
GEO0069 | Germany | C | 3 | Not delivered |
GEO0069 | Germany | D | 6 | Not delivered |
GEO0069 | Germany | D | 8 | Not delivered |
GEO0069 | Germany | C | 23 | Not delivered |
GEO0069 | Germany | G | 4 | Not delivered |
GEO0069 | Germany | A | 2 | Stable |
GEO0069 | Germany | B | 2 | Not delivered |
GEO0069 | Germany | C | 6 | Not delivered |
GEO0069 | Germany | F | 8 | Not delivered |
GEO0023 | India | A | 32 | Not delivered |
GEO0023 | India | C | 2 | Stable |
GEO0069 | Italy | A | 4 | Not delivered |
GEO0069 | Italy | B | 45 | Not delivered |
GEO0069 | Italy | C | 1 | Stable |
GEO0069 | Italy | D | 4 | Delivered |
GEO0069 | Italy | F | 5 | Delivered |
GEO0069 | Italy | F | 6 | Not delivered |
GEO0069 | Italy | F | 7 | Not delivered |
GEO0022 | Malaysia | A | 4 | Not delivered |
GEO0022 | Malaysia | B | 2 | Not delivered |
GEO0022 | Malaysia | C | 54 | Not delivered |
GEO0022 | Malaysia | D | 8 | Stable |
GEO0022 | Malaysia | G | 4 | Not delivered |
I have another 68 columns in the dataset, for many different metrics for each line.
My PBI report is focused on the metrics of each line but i want to include an overview of how we perform per country, showing a map that simply would be green if more than 70% of the cells in each country is Delivered.
I am aware that there would be a DAX solution but i am not really confident yet on coding in DAX.
I found out that a matrix visual can providem e the info i need so I wanted to know if i can use the output of matrix to create other graphs, like the map.
For now i just exported the matrix in cvs and re-uploaded it but i assume there would be a better way
thanks
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
101 | |
81 | |
62 | |
54 |
User | Count |
---|---|
249 | |
119 | |
115 | |
94 | |
70 |