Table where end user can select which columns

Question

Hi All,&nbsp;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.&nbsp;Is this easily doable?If anyone has any advice, I'd love to hear it.Thanksg00dzy

mahoneypat · Accepted Answer

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
&nbsp;
Pat

Forum Discussion

Table where end user can select which columns

2 Replies

Related content

Table selection

Dynamic Column Selection in a Table Visual

Select all columns in a table

Direct Lake Model - Calculated Column/Tables

Column-level security allows to select all table columns yet