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!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register 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 |
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 49 | |
| 46 | |
| 35 | |
| 15 | |
| 14 |
| User | Count |
|---|---|
| 88 | |
| 75 | |
| 41 | |
| 26 | |
| 26 |