Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
mjoseph111
Regular Visitor

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

mjoseph111_0-1749671205631.png

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

2 ACCEPTED SOLUTIONS
grognard
Helper I
Helper I

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

View solution in original post

grognard
Helper I
Helper I

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.

 

grognard_0-1749816487826.png

 

 

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) 

View solution in original post

4 REPLIES 4
grognard
Helper I
Helper I

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.

 

grognard_0-1749816487826.png

 

 

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. 

grognard
Helper I
Helper I

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. 

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors