Forum Discussion
How do I transpose pivot table?
I have this pivot table where I put date on Rows and some measures on Values.
But instead I want to put the date on the columns, so my dates expand horizontally.
If I try to put the date on columns, it loses the expand (+) button.
So I would like to know if there is a way to transpose it so that i can have the expand(+) button to expand the date columns.
Below is the link to my file.
https://drive.google.com/file/d/1mP4h0VHbRGNWcDyC9B9bg-qEfy3Z_hzI/view?usp=sharing
Unfortunately, Power BI does not support this. However, you can use drill-down in Power BI to achieve a similar effect. You can explore in-depth details about your data by using the drill-down, drill-up, and expand features on your visual.
Please refer to this link to learn more: Drill mode in the Power BI service - Power BI | Microsoft Learn
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
EugenioProlog The short answer is "No".
Unfortunately, Power BI does not support this. However, you can use drill-down in Power BI to achieve a similar effect. You can explore in-depth details about your data by using the drill-down, drill-up, and expand features on your visual.
Please refer to this link to learn more: Drill mode in the Power BI service - Power BI | Microsoft Learn
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
