Need help visualising data

[Ts01]

Hi all,

I have a sample table that i want to visualise in PowerBi preferably with a treemap graph.

Table:

User_ID User_Name Course_ID Course_Title Completion_Date Skill_Parent_Cat Skill_1 Skill_2 Skill_3 Learning_Hours
1 John 1 Introduction to Math 2023-01-15 Mathematics Algebra NaN NaN 15
2 Mary 2 English Grammar Basics 2023-02-02 Language Grammar Writing NaN 10
1 John 3 Python Programming 2023-03-10 Programming Python Algorithms NaN 25
4 Emily 4 Web Development 2023-04-05 Programming HTML CSS JavaScript 35
5 James 5 Data Analysis 2023-05-12 Analytics Statistics Python SQL 20
6 Sarah 6 Graphic Design Basics 2023-01-25 Design Adobe Photoshop Illustrator NaN 15
7 Michael 7 Java Fundamentals 2023-02-13 Programming Java Object-Oriented Programming NaN 30
8 Olivia 8 Marketing Principles 2023-03-17 Marketing Marketing Fundamentals NaN NaN 10
9 Daniel 9 Artificial Intelligence 2023-04-01 Technology Machine Learning Python Deep Learning 40
10 Sophia 10 Spanish for Beginners 2023-05-08 Language Spanish Conversation Grammar 20
10 Sophia 11 Financial Accounting 2023-01-28 Finance Accounting Financial Statements NaN 25
12 Ava 12 JavaScript Essentials 2023-02-15 Programming JavaScript DOM Manipulation NaN 30
13 Noah 13 Introduction to Biology 2023-03-23 Science Biology Genetics Ecology 15
14 Mia 14 Photoshop Mastery 2023-04-10 Design Adobe Photoshop Photo Editing Graphic Design 20
15 Liam 15 Android App Development 2023-05-15 Programming Java Android Studio XML 30
16 Isabella 16 Public Speaking 2023-01-22 Communication Public Speaking Presentation Skills Confidence Building 25
17 Benjamin 17 Data Science Fundamentals 2023-02-08 Analytics Statistics Python Data Visualization 35
18 Amelia 18 Music Theory Basics 2023-03-05 Music Music Theory Reading Sheet Music NaN 15
15 Liam 19 Project Management 2023-04-12 Business Project Management Leadership Teamwork 30
2 Mary 20 Creative Writing 2023-05-20 Writing Creative Writing Storytelling Editing 20

I want to visualise in a treemap the skills developed in relation to the training hours spent. I assumme that if a Course was e.g. 15 learning hours long and it developed all three skills then each skill was developed by 15/3 =5 hours.

Any idea how to proceed with this?

Thank you very much in advance.

[Anonymous · Accepted solution]

Hi @Ts01 ,

Please have a try.

Create a new calculated column to calculate the learning hours per skill. You can use the following DAX formula:

Skill_Learning_Hours = [Learning_Hours] / IF ( ISBLANK ( [Skill_3] ), IF ( ISBLANK ( [Skill_2] ), 1, 2 ), 3 ) 

Create a new table that groups the data by skill and sums the learning hours per skill.

Skill_Summary =
SUMMARIZE (
    'Sample Table',
    'Sample Table'[Skill_1],
    "Learning Hours", SUM ( 'Sample Table'[Skill_Learning_Hours] )
)

Create a new treemap visual and add the Skill_1 field to the Group section and the Learning Hours field to the Values section.

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.