Provide filter capability on all columns of a dataset .

[subbusn]

Working on a new PowerBI solution. We have an aggregated table with 100+ columns using data from multiple sources, end users want to build a capability to add/remove a set of columns which will be used for filtering and slicing of data from this aggregated table. How to implement the same. 

[Anonymous · Accepted solution]

Hi @subbusn ,

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

You may go to Power Query, add an index column and then unpivot column 'Country', 'Sales', 'Profit'.

 Add an index column:

Unpivot columns:

Then you may use decide which column to display with the slicer in Power BI Desktop.

In addition, field parameters can be used to dynamically control which columns are visible in visual objects

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Daniel29195]

@subbusn 

from what i understood, you need to create a star schema model . this would make it easy for the end user to develop slicers, filters .. . 

https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

if my understanding is wrong, please clarify the requirement . 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠: