Forum Discussion
Can this visualisation be archive? Line chart
fjam0 You need to unpivot REC1 and 2 together, in the same step (use Ctrl key or Shift key to select them together and unpivot). So your data should look like this when you're done:
Genero Cargo FRanquicia Nombre PDV Cat Value Fem REC1 5 Fem REC2 5 Fem You still have two columns for REC1 and Cat, but need only 1 column for Cat that lists the REC1 AND REC2 with the value in the column next to it.
If this still doesn't make sense, can you post what your data looks like before the unpivot please?
Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos.
I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.
fjam0 You need to unpivot REC1 and 2 together, in the same step (use Ctrl key or Shift key to select them together and unpivot). So your data should look like this when you're done:
| Genero | Cargo | FRanquicia | Nombre PDV | Cat | Value |
| Fem | REC1 | 5 | |||
| Fem | REC2 | 5 | |||
| Fem |
You still have two columns for REC1 and Cat, but need only 1 column for Cat that lists the REC1 AND REC2 with the value in the column next to it.
If this still doesn't make sense, can you post what your data looks like before the unpivot please?
Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos.
I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.
Hello AllisonKennedy ,
Brilliant! It worked just fine now. I can't tell you how much time i spend on this 🤗!
Thank you very much!
Kind Regards,
Francisco Javier Acuña