Forum Discussion

ElioAngarita's avatar
ElioAngarita
Helper I
5 years ago
Solved

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

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!

  • 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

2 Replies

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support

    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's avatar
      ElioAngarita
      Helper I

      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,