Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Hello, a question
I want to unpivot two groups of variables in my database.
First group: indicators
Second group: educational levels
both are dummy variables 1 and 0
My database looks like this:
| id_school | ind_01 | ind_02 | ind_03 | Preschool | Elementary School | Middle school |
| 23 | 0 | 0 | 1 | 0 | 1 | 1 |
| 24 | 1 | 0 | 1 | 1 | 1 | 0 |
| 25 | 0 | 1 | 0 | 0 | 0 | 1 |
What do I need?
Develop segmenters by indicator and level of education.
I need this:
| id_school | Indicators | Value | Education Levels | Value |
| 25 | ind_01 | 1 | Preeschool | 1 |
| 25 | ind_02 | 0 | Elementary School | 1 |
| 27 | ind_01 | 1 | Elementary School | 0 |
| 28 | ind_01 | 0 | Middle School | 1 |
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
| User | Count |
|---|---|
| 47 | |
| 45 | |
| 33 | |
| 33 | |
| 30 |
| User | Count |
|---|---|
| 136 | |
| 116 | |
| 58 | |
| 58 | |
| 56 |