Forum Discussion

izziehere001's avatar
izziehere001
New Member
2 years ago
Solved

Customize the columns in data point table

hi, 

 

I have a table with a lot of fields. When I click "show data points as a table", I only want a few certain columns sorted in a given order (sort of columns, not sort of rows). I can edit it in visual. But it's not saved and back to default everytime I exit the view.

 

Is there any way I can save the customized table I like?

 

Thank you.

 

Izziehere

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi izziehere001 ,

     

    Thanks for the reply from JB_AT , please allow me to provide another insight:

     

    After you adjust a visual, you can create a bookmark.

     

    Bookmark save current filters and slicers, cross-highlighted visuals, sort order, and more.

     

    This way you can quickly return to your custom view.

     

    For more information about bookmarks please refer to the official documentation:

    Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn

     

    Or you can provide me with sample data and your expected effects, please remove any sensitive data in advance.

     

    If you have any further questions please feel free to contact me.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

3 Replies

  • Hi izziehere001 

     

    This feature isn't available to my knowledge. You can arrange columns in Power Query, but you will need to check if they stay the same when you load into the report

     

    Joe

    • izziehere001's avatar
      izziehere001
      New Member

      It's not the same. Unfortunately. It's a weird order from nowhere.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi izziehere001 ,

     

    Thanks for the reply from JB_AT , please allow me to provide another insight:

     

    After you adjust a visual, you can create a bookmark.

     

    Bookmark save current filters and slicers, cross-highlighted visuals, sort order, and more.

     

    This way you can quickly return to your custom view.

     

    For more information about bookmarks please refer to the official documentation:

    Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn

     

    Or you can provide me with sample data and your expected effects, please remove any sensitive data in advance.

     

    If you have any further questions please feel free to contact me.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!