Editing Slicers in Dashboard to Only Affect That Sheet's Graphs

%3CLINGO-SUB%20id%3D%22lingo-sub-2151685%22%20slang%3D%22en-US%22%3EEditing%20Slicers%20in%20Dashboard%20to%20Only%20Affect%20That%20Sheet's%20Graphs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2151685%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20sales%20dashboard%20and%20have%20a%20main%20dashboard%20but%20want%20to%20make%20an%20exact%20copy%20of%20the%20dashboard%20tab%20and%20tailor%20each%20to%20sales%20area.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20problem%20is%20when%20I%20make%20a%20copy%20of%20the%20entire%20main%20dashboard%20tab%2C%20I%20change%20the%20report%20connections%20of%20slicers%20and%20when%20I%20do%20in%20the%20sub-dashboard%20it%20always%20changes%20the%20main.%20How%20do%20I%20make%20copies%20of%20the%20dashboard%20and%20allow%20the%20slicers%20to%20only%20affect%20the%20graphs%20on%20that%20page%20only%3F%20I%20thought%20making%20copies%20of%20the%20pivots%20would%20work%20as%20they%20seem%20to%20update%20on%20their%20own%20but%20the%20slicers%20seem%20to%20be%20universal.%20I%20also%20will%20edit%20the%20slicer%20on%20the%20specific%20tab%20only%20to%20find%20it%20changes%20all%20slicers%20and%20deselecting%20which%20pivots%20it%20affects%20changes%20all%20slicers.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20what%20is%20the%20easiest%20way%20to%20share%20the%20sub-dashboard%20tab%20by%20email%3F%20I'd%20like%20to%20send%20that%20tab%20to%20the%20manager(s)%20without%20sending%20the%20underlying%20Pivot%20cache%2Fdata.%20I%20only%20want%20it%20view-only.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2151685%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

I created a sales dashboard and have a main dashboard but want to make an exact copy of the dashboard tab and tailor each to sales area. 

 

My problem is when I make a copy of the entire main dashboard tab, I change the report connections of slicers and when I do in the sub-dashboard it always changes the main. How do I make copies of the dashboard and allow the slicers to only affect the graphs on that page only? I thought making copies of the pivots would work as they seem to update on their own but the slicers seem to be universal. I also will edit the slicer on the specific tab only to find it changes all slicers and deselecting which pivots it affects changes all slicers. 

 

Also, what is the easiest way to share the sub-dashboard tab by email? I'd like to send that tab to the manager(s) without sending the underlying Pivot cache/data. I only want it view-only.

 

Thank you.

1 Reply

@Jpalaci1 

I'm certainly not a specialist when it comes to dashboards.

Some think, not only there ... :)))

... Anyway, here are some links that might help you.

 

Share Power BI dashboards and reports with coworkers and others

----------------------------------------------------------------------------

Create and share a Dashboard with Excel and Microsoft Groups

Store your dashboard in the group

If you haven't already saved your dashboard workbook in the group you'll want to move it there. If it's already in the group's files library then you can skip this step.

  1. Go to your group in either Outlook 2016 or Outlook on the web.

  2. Click Files in the ribbon to access the group's document library.

  3. Click the Upload button on the ribbon and upload your dashboard workbook to the document library.

Add it to your group's SharePoint Online team site

  1. If you accessed the document library from Outlook 2016, click Home on the navigation pane on the left. If you accessed the document library from Outlook on the web, click More > Site from the right end of the ribbon.

  2. Click Documents from the navigation pane at the left.

  3. Find your dashboard workbook and click the selection circle just to the left of its name.

  4. When you have the dashboard workbook selected, choose Pin to top on the ribbon.

Now whenever your users come to the Documents page of your SharePoint Online team site your dashboard worksheet will be right there at the top. They can click on it and easily access the current version of the dashboard.

Tip: Your users can also access your group document library, including your dashboard workbook, via the Outlook Groups mobile app.

 

I would be happy to know if I could help.

 

Nikolino

 

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.