City, Country heat map

[JMHickman1987]

Hello Power BI community,

I am currently on a Power BI visualtion that uses a sharepoint excel sheet that combines education course data from a EU institution. The institution has courses across the EU and a big part of the visualtion is City, country that the courses are taught in. Currently, the excel sheet is organized by course title (Rows) and the column in question is labled City, country. 

Some courses are taught in multiple cities/countries. 

The data has been entered in individual cells as follows:

Single city, country:  Madrid Spain

Multiple city, country: Stockholm, Sweden ; Madrid, Spain ; Milan, Italy

The client would like to be able to slice the data by Country, city, preferably within a heat map. Is this possible? If so, how best should I organize the data within Power BI? 

Many thanks in advance,

 -Joshua

[Anonymous · Accepted solution]

Hi @JMHickman1987 ,

You can use slicers to filter visuals.

Slicers in Power BI - Power BI | Microsoft Docs

What does your data source look like? Is it possible to provide some dummy data and expected results?

Best Regards,

Stephen Tao

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

[amitchandak]

@JMHickman1987 , You need to share sample data, you need to unpivot the data

https://radacad.com/pivot-and-unpivot-with-power-bi

Power Query- Pivot, Unpivot Data: https://www.youtube.com/watch?v=FUaGQBG5YnI&list=PLPaNVDMhUXGbfdGuSsfPR1qKBRT5Ywlki&index=3