How can we hide "hide data point as a table" from selection

[dethompson97]

In the service, when I right click on a visual, I am seeing the option "Show data point as a table."  It may have always been there but I don't recall it.  Anyway, when I select "Show as a table"  I get a nice summarized listing of the values that correspond to the bars and this is fine with the users.

 How can we hide this choice.Just the summarized data is fine which is done by Show as table.

However, if I select "Show data point as a table" I get very detailed records, not the non-aggregated records and the user does not want to see this. 

Is there anyway to turn this off.  I have not been able to find anything.

Thanks!

Dawn

[Anonymous · Accepted solution]

Hi @dethompson97,

Current power bi does not support custom on 'quick action' panel.
In my opinion, I'd like to suggest you use measure to replace your original value filed on your visual. This operation can disable some of the options due to limitations.

Display a visualization's underlying data#considerations-and-troubleshooting 

Regards,

Xiaoxin Sheng

[Leo_Tzonson]

Ok, the solution is quite easy and simple. You need to go to "Fields" Pane, right click at table (or click on the 3 dots) and select hide. From this point you can test it on a visual. When you select "show data point as a table" will provide only the used columns instead of the entire data table from query. Now you might need to use your hidden table elsewhere. Go to "Fields" Pane again, right click and select "view hidden". Voila!

[dwanalytics]

This was exactly what I needed - thank you!