cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sharathm Frequent Visitor
Frequent Visitor

Allow users to choose columns from table to bookmark

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?

3 REPLIES 3
v-evelk Senior Member
Senior Member

Re: Allow users to choose columns from table to bookmark

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 Frequent Visitor
Frequent Visitor

Re: Allow users to choose columns from table to bookmark

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 Senior Member
Senior Member

Re: Allow users to choose columns from table to bookmark

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

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 293 members 3,165 guests
Please welcome our newest community members: