Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I am failry new to the power bi and facing the below challenge.
I have in total 4 headers (2 as rows and 2 as columns). I am unable to create charts/ get insights from the data because of how it is structured. Please see the below image.
What I want is -
1. I should be able to understand what level of worker is doing resp1,2,8,9 (example) and across countries
2. Percentage/count of responsibilities performed by level 3/4 worker across countries
3. I should also be able to see the work distribution group responsibility wise (example - how many levels are involved to complete group 1 responsibility)
Any help on this is greatly appreciated 🙂
Your data should be unpivoted, and the nested columns make it trickier but it is doable. If you can provide a link to a sample file with dummy data, someone in the community will likely provide the M code/steps to show how to do it.
Pat
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.