Forum Discussion

Liphor's avatar
Liphor
Brass Contributor
Feb 26, 2022
Solved

Interactive Dashboard chart from multiple splicers

I have created 3 different charts of the same type from 3 different sets of data. I create them by using pivot table and splicer. How do I transform them into a single  dashboard chart but able to sh...
Charting
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Feb 26, 2022

    Liphor Something like in the attached file perhaps? It's just a very rough model, based on your data and done with Power Pivot and would  require further refining though. Use the slicers to select the year and region.

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Feb 26, 2022

Liphor Something like in the attached file perhaps? It's just a very rough model, based on your data and done with Power Pivot and would  require further refining though. Use the slicers to select the year and region.

 

Liphor's avatar
Liphor
Brass Contributor
Feb 26, 2022
Your proposed solution looks good, However because I have no knowledge of Power Pivot so I have to spend a couple of days to learn about this function. Where is in located in the excel menu. I am currently using excel 2016 and 2021 on my laptops. I would also like to ask whether I could add additional line like cumulative and mean values in this graph. Thank you for introducing me to power pivot.
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Feb 27, 2022

    Liphor Not sure about 2016, but in 2021 you should see Power Pivot in the top menu as shown in the top right-hand corner of the picture below.

     

     

    • Liphor's avatar
      Liphor
      Brass Contributor
      Feb 28, 2022
      May I know are the tables link by connection or pivot table.
      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor
        Feb 28, 2022

        Liphor In this particular case I connected to each of the rainfall tables with Power Query, where I transformed them to a usable format and in one table. Then loaded the single table into the Data model (i.e. Power Pivot) from which the Pivot Chart was created.

        All was intended to demonstrate what's possible, but as said it's very rough and if I would start from scratch I would probable do it differently. I.e. create a single (tabular) database from the start, use proper dates rather than year numbers and short codes for the months.

Resources