Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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"
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"
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
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".
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".
You can then create a matrix visual and a slicer like below. The slicer is able to filter the columns in the matrix visual.
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.
User | Count |
---|---|
9 | |
8 | |
6 | |
6 | |
6 |