reorder columns in table in published report

[AndrewPF]

I have a table in a report which looks like this: 

and I want to add the facility for the end user to reorder, or select/deselect, specific columns in the published report. 

It's to make it easier to do a side-by-side comparison of, for example. Administrator and Owner. 

Any ideas? 

[Idrissshatila · Accepted solution]

Hello @AndrewPF ,

What you could do is group these columns in a field parameter and it will be add it in a slicer and then it would allow you to add the columns you want and get arranged as per your selections.

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin