Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
How can I disable or hide the 'Show data point as a table' option in Power BI visuals?
Solved! Go to 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
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”.
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 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”.
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.
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
Thank you so much. This is really helpful.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.