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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
id013
Helper V
Helper V

Is there a way to actually edit the table that you see when you click on show data

Is there a way to actually edit the table that you see when you click on "show data" (the table you see when you click on show data on any visualization)? 

 

There doesn't seem to be any way to control how the data is formatted there. It  just seems to take the appropriate values and sticks them in an abitrary table. I would like to be able to control font, font size, column widths etc, also I'd like the option to choose if it will show column or row totals. 

 

1 REPLY 1
gckcmc
Resolver I
Resolver I

I'm not aware of the ability for formatting of the "show data" option.  IMHO, it's really there for a quick glance at underlying data that forms the visualization, but not intended to be "pretty".

 

I would suggest either having a visualization with tables, for which you can then format the data to your liking and publish that, or direct users to export the data, and then render the formatting in Excel.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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