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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
MelStaunton
Helper III
Helper III

Ellipsis (or "MoreOptions") for table chart not showing

Hi there,

 

I have published a report. The ellipsis or "More options" show in the desktop but not in the service. I need to be able to export the

data.

 

snap1 - Power BI Desktop.png

Snap2 - Power BI.png

 

The same report has the same table with different aggregations and shows the ellipsis just fine.

 

Why would that be??

 

I have brought the table to the front, thinking slicers might overlay the popup.

I have recreated the table from scratch to no avail.

I have copied the table that shows the ellipsis, not it.

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @MelStaunton 

 

What you will need to do, is log into the Power BI Service.

Then go to the App Workspace.

Click on the Reports section to see all the reports.

Then click on the settings Icon as shown below.
image.png

Then make sure to Toggle the Visual Header to On as shown below.

 

image.png





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

8 REPLIES 8
MelStaunton
Helper III
Helper III

@GilbertQ 

hopefully you can answer this one, too. I havea similar problem, but verified all visual headers are turned on this time.

 

In Desktop I have two charts beside each other, both show drill down opportunites, rows and columns.

 

Yet upon publishing to service only one of the visuals, the one onthe right keeps drill down....why?2020-02-20 14_43_33-Salesforce BBS Dashboard V1 - Power BI Desktop.png2020-02-20 14_46_05-Salesforce BBS Dashboard V1 - Power BI.png

Hi @MelStaunton 


Can you make sure that you have clicked on the "Reset to Default" to ensure it is back to the default settings of the uploaded report?

 

 

image.png





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

@GilbertQ  It is. And it doesn't show?

Hi there

Can you have a look at the visual headers format property for your visual and see what they are set to?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User
Super User

Hi @MelStaunton 

 

What you will need to do, is log into the Power BI Service.

Then go to the App Workspace.

Click on the Reports section to see all the reports.

Then click on the settings Icon as shown below.
image.png

Then make sure to Toggle the Visual Header to On as shown below.

 

image.png





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hi GilbertQ,

 

thanks for that.

 

My settings look like this...no visual header toggle. But I went back to the Desktop and turned the visual header on there. Now it shows.  Even though the other pages with the same table don't have the visual header turned on and show the options, too.

 

Thanks for your help!!

Snap3-Power BI.png

Hi there

Thanks for letting me know.

The image you sent was the settings for the Dashboard. If you go to the settings for the report you will see the visual headers.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

You are very much correct 🙈. Thank you!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.