The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
Can anyone help please? I have a report which currently displays as this. What I need is for the categories A-G to be in columns of their own and within that column if there is a peformance outcome for it to show within that column. I include the power bi report of how it looks now also.
https://drive.google.com/file/d/13EVmkQb8LJMDprpxmCZTqghN8CmrwukE/view?usp=sharing
Solved! Go to Solution.
Hi,
In Power Query select the categories column, select Pivot Column from the Transform toolbar, in the Values column select Performance Outcome, in Advanced Options select Don't Aggregate.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi,
In Power Query select the categories column, select Pivot Column from the Transform toolbar, in the Values column select Performance Outcome, in Advanced Options select Don't Aggregate.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Thank you so much! I had been trying to pivit without much luck but the 'Don't aggregate' was the bit I missed! 🙂
No worries, happy to help 🙂
User | Count |
---|---|
81 | |
78 | |
37 | |
34 | |
31 |
User | Count |
---|---|
93 | |
81 | |
60 | |
49 | |
49 |