Forum Discussion
Pivot replication in PowerBI
How do i recreate this Pivot chart in tab SAP source https://docs.google.com/spreadsheets/d/1gN8AGcn6glEuZU0DTvAfgcPPU1n36QY-/edit?usp=sharing&ouid=104129043494164133703&rtpof=true&sd=true From the Source Data tab?
My PBIXhttps://drive.google.com/file/d/1LP6PDoz9HtQDg5Minqnv9GJnOBauNEDq/view?usp=sharing
1 Reply
Yrstruly2021 , I doubt you can create a complex table like this. Few workarounds are
if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428Power BI How to get the P&L formatting right: https://youtu.be/C9K8uVfthUU
Power BI How to get two columns format Profit and Loss Statement(P&L) right: https://youtu.be/WLg85yiMgHI
https://medium.com/microsoft-power-bi/power-bi-formatted-p-l-with-custom-sub-totals-and-blank-rows-e39ca822908a
