Column Customization to include show/hide columns

[Anonymous]

Column Customization needs to hide some column based on the requirement: Based on filters to display the columns

For example when you select A in filters columns should show 1,2,3,4,5
or when you select B in filters  rows columns show 2,3,4,5,6 and removed 1 row

or when you select c in filters rows columns show 1,3,4,5,6 could show

Note : without out bookmark or withouts filters is possible could help me on it

[PC2790]

Giving a provision of selecting columns is actually possible using the new feature called field parameter.

See if it caters to your requirement.

Fields parameters in Power BI - SQLBI

[TomMartens · Accepted solution]

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