Table where end user can select which columns

[g00dzy]

Hi All,

I'm wanting to make a report whereby the end user can generate a table with columns they want based off the fields in our dataset.

Almost like a reporting suite, where one user may specify Name, Address, Payment Type, Amount and Currency and another user may specify Date of Sale, Business Number, Account Code and Segment.

Is this easily doable?

If anyone has any advice, I'd love to hear it.

Thanks

g00dzy

[mahoneypat · Accepted solution]

You can use the Field Parameters feature to do that. Create the parameter with the columns/measure you want them to choose from (and keep box to add slicer to page checked), and then create a Table visual that using the parameter column only.

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Pat

[sevenhills]

Are you looking somthing like this?

https://blogs.perficient.com/2022/06/29/power-bi-dynamic-columns-in-a-table/