Forum Discussion
Interactive Dashboard chart from multiple splicers
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 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.
- May I know are the tables link by connection or pivot table.
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.
- Is it possible to show me how would I create a single data base from the 3 tables. I mean how would the matrices look like. Can my database be expanded over time. For your info the dates I have are just years and months.