Select columns to show on table visual

[gmaciel]

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?

[Anonymous · Accepted solution]

HI @gmaciel

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

[Anonymous]

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]

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

[Anonymous]

Thank you @AllisonKennedy  for your suggestion, but It could not solve my problem ( maybe I did something wrong)

but in Matrix,still there are 2 problems :

1)it does not put elemets of each attribute(Industry, Region and vertical)

2) the calculation for all attribute are equal which is not correct.

Regards,

Matin