Forum Discussion
Advocate IIReplicating excel pivot table in power bi
Hi Danniel You can achieve this by creating a matrix visual in Power BI Desktop
Steps:
1. Bring Matrix visual in the canvas
2. Set Month in the Column and your two numerical columns or measure in the Values
3. It will look like this
If you are happy with this then you are good to go. Or you can try one more steps
4. Enable "Switch values to rows" to get this clean format.
Final Results:Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!
Super UserHi Danniel You can achieve this by creating a matrix visual in Power BI Desktop
Steps:
1. Bring Matrix visual in the canvas
2. Set Month in the Column and your two numerical columns or measure in the Values
3. It will look like this
If you are happy with this then you are good to go. Or you can try one more steps
4. Enable "Switch values to rows" to get this clean format.
Final Results:
Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!
Advocate IIThank you! This is exactly what I was looking for!