How can I disable or hide the 'Show data point as a table' option in Power BI visuals?

[mjoseph111]

How can I disable or hide the 'Show data point as a table' option in Power BI visuals?

[grognard · Accepted solution]

I'll start a writeup later today but right now this might be the answer to your question: Solved: Removing the option to see "Data Point Table" from... - Microsoft Fabric Community

[grognard · Accepted solution]

I'll start a writeup later today but right now this might be the answer to your question: Solved: Removing the option to see "Data Point Table" from... - Microsoft Fabric Community

[mjoseph111]

Thank you so much. This is really helpful. 

[grognard · Accepted solution]

The simplest way to hide the option 

The simplest way to hide the option is to create a new measure that summarizes the value you are displaying. For example in my model where "stats" is the table I am using and [GetItNow] is the column I want to hide, I can create a measure like this: 

GetItNow (Measure) = SUM(stats[GetItNow])

and replace the data in the pie chart with that column, to have the "Show Data Point as Table" Option disappear.

Note: Make sure you select a “New Measure” instead of a “New Column”. 

Taking it further 

While the option previously mentioned will prevent users from seeing ‘show data as table’ in the interface, it will not actually hide the data. To do this you will need to assign roles and enable Object Level Security using the Tabular editor tool, A good summary of how to do this can be found here. 

External References

Chris Webb's BI Blog: Is Power BI’s “Show Data Point As A Table” Feature A Security Hole? 

Release Tabular Editor 2.20.2 · TabularEditor/TabularEditor · GitHub (Free version) 

[mjoseph111]

Thank you so much. This is really helpful.