Forum Discussion

ElioAngarita's avatar
ElioAngarita
Icon for Helper I rankHelper I
5 years ago
Solved

How do i save "Show data point as table" changes?

It would be nice to save a determined "preset" of the data people get when they right click and "Show data point as table" Why? I'd love to offer that information in a ready-to-use report.    Curre...
Need Help
Tips and Tricks
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi ElioAngarita ,

     

    Generally speaking:

    If the Value is a column in the visual, 'Show Data point as a table' is available. You can just right click on the data element in the visual and will see the option as the picture you haved posted.(Multiple column fields are also satisfied)


    If the Value is a measure in the visual, 'Show Data point as a table' is not available.

     

    related solution link: Show Data point as a table not working in Power BI... - Microsoft Power BI Community


    If the problem is still not resolved, can you further describe your information, provide the corresponding data (delete sensitive information) and screenshots of the expected results, so that I can do accurate tests as soon as possible.

    Best Regards,
    Henry

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
5 years ago

Hi ElioAngarita ,

 

Generally speaking:

If the Value is a column in the visual, 'Show Data point as a table' is available. You can just right click on the data element in the visual and will see the option as the picture you haved posted.(Multiple column fields are also satisfied)


If the Value is a measure in the visual, 'Show Data point as a table' is not available.

 

related solution link: Show Data point as a table not working in Power BI... - Microsoft Power BI Community


If the problem is still not resolved, can you further describe your information, provide the corresponding data (delete sensitive information) and screenshots of the expected results, so that I can do accurate tests as soon as possible.

Best Regards,
Henry

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ElioAngarita's avatar
ElioAngarita
Icon for Helper I rankHelper I
5 years ago

Hi Henry! Thank you for your answer.

 

I don't have any issue with "show data point as a table" as i already have it avaliable when i click on my visual.

 

The thing is that I do have an issue with the information that i get from there. I know that i can move the fields around (columns) and even ADD more that were not avaliable. But, i haven't been able to SAVE the changes i do to this (re-ordering, new values, erase values). The whole idea is letting users export this data into a CSV file and work, and i would love it to be all organized already but i can't.. as soon as do my changes and then click "Back to report" everything gets back to how it was.

 

How do i change this? i want to have a report ready from the visual.

 

    • DieterG's avatar
      DieterG
      Frequent Visitor
      2 years ago

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

  • rsbin's avatar
    rsbin
    Icon for Community Champion rankCommunity Champion
    4 years ago

    ElioAngarita, v-henryk-mstf ,

    Elio,  I am facing the exact same issue you describe here in this thread.

    Did you ever find a solution to this issue?

     

    Thanks and kind regards,