Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello all users!
I requiere your help with this challenge! It is about a visualisation easy to create in Excel but I can´t find the way to replicate it with Power BI or maybe it isn't posible.
So with images I think it will be much easier:
I appreaciatte every comment or suggestion.
Regards,
F.
Solved! Go to Solution.
@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.
https://sites.google.com/site/allisonkennedycv
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as 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 C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
You need your Genero (Gender) in the Legend just like you have it in your Excel line cart. It's in the Legend.
Hello @Greg_Deckler ,
Thank you for you super fast reply. Unfortunately, PowerBI doesnt let me put Gender on the legend option. Thus, I can upload my pbix file if it's more easy to view.
Regards,
F.
@fjam0 Thanks for the pictures - they're helpful. From what I see, you have two fields in the values, REC1 and REC2. You cannot use both a legend and two values, only one OR the other.
If you are wanting these displayed as category axis, then they need to be unpivoted so that you have a table that looks like this:
Gender | Category | Average |
Male | REC1 | 4.3 |
Female | REC1 | 4.4 |
Male | REC2 | 4.4 |
Female | REC2 | 4.4 |
To do this, click Transform Data to open the Query Editor, navigate to your data table that you're trying to graph, and select all the REC values, then click Unpivot (or better way might be to select all the columns that are NOT REC values and click Unpivot other columns, just depends on how much your data will change from Excel).
Then rename the 'Attribute' to 'Category' and 'Values' to 'Average' or whatever names you prefer.
Once you've done that, you can put Category in Category, Gender in Legend and Average in values.
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.
https://sites.google.com/site/allisonkennedycv
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as 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 C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Hello @AllisonKennedy .
Thank you so much for your time and great answer.
I tried what you say and I have partially solved the issue.
Thanks again Allison
Regards,
F.
@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.
https://sites.google.com/site/allisonkennedycv
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as 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 C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
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
UP!🤗
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |