Allow users to choose columns from table to bookmark

[sharathm]

Hello,

          Currently, I have a table with around 250 columns of data and 50 users looking for different columns. Is there a way to allow users to bookmark a view with the columns that they are interested in from the table?

[v-evelk]

Hello,

I am unsure that clearly understand your issue.

I suppose, you could transpose your data and add some slicer into a report to allow users to pick necessary information.

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

[sharathm]

Thanks @v-evelk for your response.

Slicer can be used to filter number of rows but not columns.

Please find below scenario.

Table in the report shows 250 attributes  Eg: Store Name, City, State, Address, Col4, ............... Col250.

User1 is interested to see data of Columns 1-10 only. 

User2 needs data of Col1, Col3, Col5, ......... Col250 only

...

User50 needs data of Col1, Col10, Col100, Col250.

How can respective user create their own bookmark with the columns that they need.

Note - Users needs to download data with relevant columns and share it with other teams. Instead of downloading all 250 attributes data and clearing off the columns that are not needed everytime is a tedious task, also creating individual report for each user and maitaining it (add/remove columns) is also a overhead, In this context, can we allow user to choose their own list of columns?

I hope this clarifies.

Please let me know if you have more questions or need more details.

Regards,

Sharath

[v-evelk]

Hi Sharath,

I got it, but I am afraid that it's impossible, at least at custom visual development level.

You can also clarify this moment in Desktop thread -- they have more expertise regarding specific usage of Power BI.

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com