+ Reply to Thread
Results 1 to 3 of 3

Dashboard linked to multiple table's

  1. #1
    Registered User
    Join Date
    07-28-2020
    Location
    London
    MS-Off Ver
    365
    Posts
    6

    Question Dashboard linked to multiple table's

    I need some help. I've been asked to create a dashboard for our customers to make it easier for them to see our monthly KPI. etc while at the same time being able to delve into more detail if needed.

    This data comes from a number of sources. My KPI report, our It logging system, Email platform, Active directory etc.

    What id like is to get is a Dashbloard front screen which has 2 choices one for the list of 7 organisations and second for 2 customer types they cover. With a list of charts that visualised the data to be display. Some KPI values are for all organisations and others are split between the two customer types. I also need to then be able to split the backing data down to each organisation and customer type depending on what is select from the dashboard

    I initially created a sheet to hold all the calculations for the charts and on the dashboard created two slicers which picked there data from the calc sheet. I would ideally like this to then adjust those KPI where customer type can change. Along with the charts that summarise the backing data . Such number of Active inactive Ad accounts email accounts etc. Plus filter all other backing data tables(Not pivot tables).

    I have number of issues which I'm struggling with:-

    1. If I select an item from the slicer the associated table is filtered. I'm just not sure how to work out what was selected (It changes the row reference depending on what you select.) So that I can then pull data from relevant table and KPI sheet using formulas such as countif.
    2. How to get those two slicers to filter all the other tables(Not pivot tables) to match options chosen on the front screen.
    3. Are slicers my best choices because for somethings like , list of emails and there status organisation could look at both customer types together and with others such as KPi they would only be looking at either customer type. I wonder if it might be easier to restrict it to just choosing one Organisation with one customer type.
    4. How to filter all the tables to match the Front dashboard choices
    5. Also allow the customer to filter the backing data further by things such as Active/inactive email accounts. Without adjusting the charts on the front screen.
    6. To do this with as little if any VB code
    Last edited by locka; 12-13-2020 at 06:54 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,110

    Re: Dashboard linked to multiple table's

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook.

    I'd be inclined to use Power BI for this sort of task.
    Last edited by AliGW; 12-13-2020 at 07:00 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    07-28-2020
    Location
    London
    MS-Off Ver
    365
    Posts
    6

    Re: Dashboard linked to multiple table's

    Hi AMAliGW thanks for the reply, I wish I had access to Power BI and this might happen in the future but not for now. Would love to attach spreadsheet but there a lot of data contained and would take ages for me to santaise and even then to explain some of the data like my kpi workings etc. I hoped that my explanation would help.

    Perhaps the first two points would be good

    1. How to find out which options have been sliced from a table and use in formula such as countif (Data!A1:700,Slicer value")
    Last edited by locka; 12-13-2020 at 02:18 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 06-08-2018, 05:08 AM
  2. Replies: 0
    Last Post: 03-02-2018, 08:23 AM
  3. Dashboard with linked images running too slow
    By Jayy2121 in forum Excel General
    Replies: 4
    Last Post: 06-19-2017, 10:28 AM
  4. Help with Macro to dump multiple sheets into one master sheet linked to Pivot Table
    By rickblasing in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-10-2015, 03:38 PM
  5. Access Database - Refreshing Linked Dashboard
    By Xcelguy in forum Access Tables & Databases
    Replies: 1
    Last Post: 11-16-2013, 07:32 AM
  6. Replies: 0
    Last Post: 09-10-2012, 09:19 AM
  7. Updating Dashboard of 'Linked' information based on criteria found in Master Worksheet.
    By chad.kleve in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-04-2012, 05:07 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1