Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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.
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.
@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
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |