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

[Anonymous]

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 · Accepted solution]

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.

[venal]

@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.

[GilbertQ]

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]

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

[GilbertQ]

Hi there

Currently that is not possible to alter it in the way you are looking to do.

I would suggest looking for an idea to vote for at https://ideas.powerbi.com