topic Re: How can I disable or hide the 'Show data point as a table' option in Power BI visuals? in Custom Visuals Development Discussion

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

mjoseph111 — Wed, 11 Jun 2025 19:47:56 GMT

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

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

grognard — Thu, 12 Jun 2025 14:03:50 GMT

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

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

grognard — Fri, 13 Jun 2025 12:12:17 GMT

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)

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

mjoseph111 — Fri, 20 Jun 2025 18:09:20 GMT

Thank you so much. This is really helpful.

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

mjoseph111 — Fri, 20 Jun 2025 18:09:31 GMT

Thank you so much. This is really helpful.