How to set pivot table default set to expend all all column ?

[Anonymous]

Hi All

when i have pivot table . after i upload to web service , i will get table as below

I need to manually expend all column. so that i can view all column. for ipad PBI app they don't all user expend all , so user cannot view those column.

any work around ?

Paul

[Anonymous · Accepted solution]

Hi @Anonymous ,

According to my test, status of the report published to service would be the same as it in Desktop.

You could click the Drill-down button to expand all down level in Desktop.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Eyelyn

Thank you very much for your sharing , i learn one more trick.

Paul

[Fowmy]

@Anonymous 

You cannot set the status to be expanded for all rows by default, If you right-click and select Expand and select all, you can expand all at once

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn