Forum Discussion
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'?
- Anonymous6 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
- GilbertQSuper User
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"
- AnonymousNot 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
- GilbertQSuper UserHi 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
- venalMemorable 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:-
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.
- AnonymousNot 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.