Adding fields to "Show Data Point as Table" data & saving the resulting table

[ElioAngarita]

Hello,

Is it possible to save fields that you add on the table that is created when "show data point as a table" is chosen? I am able to add them (through the visualization option - see picture) but when I click to go back to report (after i modify my table and export it) and then do it again, the fields I added are gone.

I'm hoping to add a little more detail to those tables when users look deeper into the data without them having to modify it everytime.

Thanks!

[v-janeyg-msft · Accepted solution]

Hi, @ElioAngarita 

I reproduced your scene and found that it indeed can't be saved. I think it is by design and can't change.

I recommend you to use the drill through function, it can almost achieve the same effect.

Check it:

Set up drillthrough in Power BI reports - Power BI | Microsoft Docs

You need to put a table visual in the drillthrough page, and then add these fields to the visual.

'Drill through' will automatically drill to the data point of the data point you selected.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards

Janey Guo

[ElioAngarita]

Your suggestion was solved my issue and my requirement 100%! Thank you so much! Now with the drillthrough I'll be able to customize what i want to show and make it even more dynamic.

Thank you again,