Column Customization to include show/hide columns

Hey Anonymous ,

not sure if I understand your requirement exactly, but I assume you can achieve this using the new field parameters feature: Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Docs

And some data modeling
I created a simple table with columns col1, col2, col3 and amount
I created a table called parameter using the parameter fields feature:

I created a table called slicer

I created a table called unique columns, this table can be hidden in the report view, but is essential for creating the relationships

The data model looks like this:

This is how it looks like in action:

Here you will find the pbix: https://tommartens-my.sharepoint.com/:u:/g/personal/tom_minceddata_com/Ebz1SZzRM_5PiWsOt0XOBUgBW56ilmLV0jMJEtFF7xTsxg?e=mISueC

Hopefully, this is what you are looking for.

Regards,

Tom