Forum Discussion
Select columns to show on table visual
Hello,
I need to make a simple extraction table on Power BI.
I'll import from the server a table with over 40 columns, and I'd like to let the user select (maybe with a filter) which columns he wants to see on the table (visual), that he will later export.
Any ideas?
- Anonymous7 years ago
HI Anonymous
This can be done. This article explains the step by step details explained.
https://powerpivotpro.com/2018/01/dynamic-attributes-power-bi-report/
Thanks
Raj
4 Replies
- AnonymousNot applicable
HI Anonymous
This can be done. This article explains the step by step details explained.
https://powerpivotpro.com/2018/01/dynamic-attributes-power-bi-report/
Thanks
Raj
- AnonymousNot applicable
hi Anonymous ,
Thank you for the useful link, but still I have a problem, this attributes were put on rows in the table , but I need them as a column.
do you have any suggestion for solving this problem?
Regards,
Matin
- AllisonKennedy
Community Champion
Use a matrix instead of a table, and put the attributes in 'columns' field and turn 'show on rows' to ON. https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2017-feature-summary/#valuesOnRows