Excel Forum

Dashboard charts and Pivot filed chooser

Jacqui Donnelly

Member

Members

Power BI

Forum Posts: 6

Member Since:
August 5, 2021

Offline

October 6, 2022 - 9:04 pm

I have designed a dashboard basic enough and have hidden sheets etc for users to only interact with the charts - on the dashboard though if you double click on the chart it opens the PivotChart Field box or offers in the Pivotchart Analyze to open the field list on the ribbon - is there anyway of locking this on the dashboard to stop users clicking on these buttons and changing the charts?

Mynda Treacy

Admin

Forum Posts: 4647

Member Since:
July 16, 2010

Offline

October 7, 2022 - 8:05 am

Hi Jacqui,

You can protect the sheet objects (charts, images etc.). By default all objects are locked, you just need to enable the protection on the sheet via the Review tab of the ribbon > Protect Sheet. Note: if you want users to be able to interact with Slicers etc., then you need to unprotect these objects before protecting the sheet and you need to select 'use PivotTable and PivotChart'.

Top Posters:

Catalin Bombea: 1864

SunnyKow: 1432

Anders Sehlstedt: 886

Purfleet: 414

Frans Visser: 346

David_Ng: 306

lea cohen: 241

Hans Hallebeek: 227

Jessica Stewart: 219

A.Maurizio: 213

Newest Members:

Anya Ledwith

Mark Melvin

Stuart McInnes

Naji Moukhachen

Robert Mason

Debora Cohen

Kris Whitaker

Rajesh Jawajala

Todd Heckman

Sarah Dennis

Forum Stats:

Groups: 3

Forums: 24

Topics: 6641

Posts: 29138

Member Stats:

Guest Posters: 49

Members: 33095

Moderators: 2

Admins: 3

Administrators: Mynda Treacy, Philip Treacy, Jessica

Moderators: Velouria, Riny van Eekelen

Dashboard charts and Pivot filed chooser|Dashboards & Charts|Excel Forum|My Online Training Hub