Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to Modify Columns after clicking 'Show data point as a table"

I have some bar graphs that users want more information on. They want to right click on 'show data point as a table' and get more information on the underlying data. How do I modify the columns that are shown after the user clicks on 'show data point as a table'?

  • Anonymous's avatar
    Anonymous
    6 years ago

    For some weird reason, Date Fields don't come in to "Show data point as a table". To resolve, duplicate the desired date field and make it Text.

     

    In order to remove fields from this view, you need to 'Hide' them in Power BI Desktop.

     

    I also posted on stack overflow here.

5 Replies

  • Hi Anonymous 

     

    You will need to click on the report and then select settings

     

     

    Once you select settings scroll down and you can change the export options as shown below

     

    "Summarized data and underlying data"

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you for the reply. I do currently have underlying data turned on but am still not able to modify columns that come out of show data point as table. 

       

      I added some pictures to make my question clearer. Thank you for any help.

       

      Warm Regards,

       

      zach

  • venal's avatar
    venal
    Memorable Member

    Anonymous 

    I tried to re-pro the issue from my end and seeing that cant able to edit it in "Show as a table" data.

    If the columns are need to change in main visual, please double click the column from "Axis/Value" and change the column name.

    Referred Links:-

    https://docs.microsoft.com/en-us/power-bi/desktop-see-data-see-records#use-see-records-in-power-bi-desktop

    https://docs.microsoft.com/en-us/power-bi/visuals/service-reports-show-data#considerations-and-troubleshooting

     

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
    In case it does not help, please provide additional information and mark me with @

     

    BR

    venal.

  • Anonymous's avatar
    Anonymous
    Not applicable

    For some weird reason, Date Fields don't come in to "Show data point as a table". To resolve, duplicate the desired date field and make it Text.

     

    In order to remove fields from this view, you need to 'Hide' them in Power BI Desktop.

     

    I also posted on stack overflow here.