Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
So I have a dataset that looks something like this -
Product | Plan Gross Sales | Plan Net Sales | Plan Profit | Quota Gross Sales | Quota Net Sales | Quota Profit | YAGO Gross Sales | YAGO Net Sales | YAGO Profit |
Brand A | 120 | 80 | 40 | 115 | 80 | 45 | 100 | 75 | 45 |
I would like to group metrics and display in a visual like this -
Brand A | Plan | Quota | Yago |
Gross Sales | 120 | 115 | 100 |
Net Sales | 80 | 80 | 75 |
Profit | 40 | 45 | 45 |
How can I do this?
Solved! Go to Solution.
Hi @nj-matt ,
Check the following steps in Query editor.
1# Select Product column use Unpivot other columns feature.
2# Add two custom columns as below.
3# Create the visual.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi @nj-matt ,
Check the following steps in Query editor.
1# Select Product column use Unpivot other columns feature.
2# Add two custom columns as below.
3# Create the visual.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@nj-matt , refer if this can help
https://kohera.be/blog/power-bi/how-to-unpivot-twice/
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |