Forum Discussion
How can I disable or hide the 'Show data point as a table' option in Power BI visuals?
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
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)
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)
Thank you so much. This is really helpful.
