Dynamic columns selection in table

[Snagalapur]

Hi All,

Please suggest - How to select or unslect columns in table based on user controls EX: below

Thank you.

[rohit1991]

Hi @Snagalapur . You can achieve dynamic column selection based on user controls in various ways, depending on the platform you're using. In Excel, you can leverage filters, slicers, or Power Query to dynamically show or hide columns. If you're working with Power BI, field parameters allow users to select which columns to display in a table. For web-based applications using React, Angular, or similar frameworks, you can implement checkboxes or toggle buttons that allow users to control the visibility of columns dynamically, often using JavaScript and libraries like DataTables.js. If you're working with SQL or database reporting tools, dynamic SQL queries can be used to adjust displayed columns based on user input.

[zenisekd · Accepted solution]

Hi @Snagalapur  I guess you could use a filed parameter.

Something like here: https://www.youtube.com/watch?v=tb3eDmA7CqE&ab_channel=ChristinePayton