Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
etaks90
Frequent Visitor

Adapt table-columns via slicer

Hey, I am about to create a table with a potentially very large amount of columns. Therefore it is crucial to allow easy column-selection. I would like to do this via a slicer. But if there is a better solution please let me know. I created two tables to use here as a minimal example. Let us say I have below data in table "data_table"

etaks90_0-1677862512753.png

which I would like to visualize in table-visual "visual_data_table". Now there should be the possibility to select (e.g. via a slicer) which columns shall be represented in visual "visual_data_table". Let us therefore see below table "name_mapping"

etaks90_1-1677862592339.png

which sould be represented in slicer "visual_name_mapping". In this table "name_mapping" I have a row for each column of table "data_table".

How to

1.) select the columns of visual "visual_data_table" based on slicer "visual_name_mapping"?

2.) map the column name in visual "visual_data_table" from "Column name original" to "Column name map"?

3.) create an additional slicer with selections "parametrization A" and "parametrization B" where on selection the corresponding columns for the selected parametrization are represented in visual "visual_data_table"? (If choosen "parametrization A" I would like to see Column B, C, D. If "parametrization B" is choosen I would like to see Column A and C).

 

Thank you and BR, Oliver

 

 

1 REPLY 1
v-jingzhang
Community Support
Community Support

Hi @etaks90

 

For the first slicer, you may refer to my solution as below. 

 

First in Power Query Editor, add an Index column to "data_table". Select this Index column and unpivot other columns. You will get a table like below. Rename "Attribute" column to "Column name". 

vjingzhang_0-1678083320105.png

 

Then in Power BI Desktop, create a relationship between two tables on [Column Name] in "data_table" and [Column name original] in "name_mapping". Use "name_mapping" to filter "data_table".

vjingzhang_1-1678083379148.png

 

You can then create a matrix visual and a slicer like below. The slicer is able to filter the columns in the matrix visual. 

vjingzhang_2-1678083507917.png

 

This is the closest workaround I can think of. However for the second "parametrization" slicer, I cannot think of a workaround yet. The pbix has been attached at bottom for your reference. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.