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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
harinik
Frequent Visitor

Disable show data point as a table option

Hi all,

I want to disable the 'show data point as a table' option. I do not want to create a measure. For the bar chart I am using, I need only the columns, but that enables the 'show data point as a table' which I dont want. In the data/drill pane, I have turned it off.

harinik_0-1697033206038.png

 

 


Even in service it is turned off.

harinik_1-1697032439252.png


But even then I get that option

harinik_2-1697032524634.png


What can be done to turn it off. Nobody wants to see the underlying dataset. I am surprised that there is no official documentation to turn off this feature but only documentation explaining about it. I have spent hours to disable this option and am really shocked to see that there is no way to turn it off. We go to lengths to hide data to different users using RLS and by restricting access and here we have with one click of a button to see the whole dataset!!
https://learn.microsoft.com/en-us/power-bi/create-reports/end-user-show-data?tabs=powerbi-desktop#co...

 

Or if it cannot be turned off , is there a way to limit the columns displayed when 'show data point as a table' is clicked??

 

Have I missed something? Can you please help me out.

Thank you very much




1 ACCEPTED SOLUTION
harinik
Frequent Visitor

Hi, 
So i created measures for the columns that are aggregated in the visual. Seems using measures instead of columns is only solution at the moment. Or use a table visual that does not support this option. But it would be really nice if Microsoft can render a solution to this problem. 
Atleast in service for users with viewer access should not have the 'show data point as a table' option. It can be made available in deskstop or in service for users with admin access but not for others.

View solution in original post

1 REPLY 1
harinik
Frequent Visitor

Hi, 
So i created measures for the columns that are aggregated in the visual. Seems using measures instead of columns is only solution at the moment. Or use a table visual that does not support this option. But it would be really nice if Microsoft can render a solution to this problem. 
Atleast in service for users with viewer access should not have the 'show data point as a table' option. It can be made available in deskstop or in service for users with admin access but not for others.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors