Notifications
Clear all
Dashboards & Charts
2
Posts
2
Users
0
Reactions
63
Views
Topic starter
Hello Philip
Thanks you to have me, thru you tutorial on YouTube I have built 2 dashboard in different sheets, but in one file excel, the data are taken from the server.
I am using Excel 2013 and I have two problems.
I have analyzed sales in weekly base and monthly base, but in one chart when I use slicer it change format from monthly bases in weekly base.
In other chart I have analyzed the topology of Point of Sales in Sales Weekly base, but I use slicer it changes format from monthly bases in weekly base. In other chart I have analyzed the topology of Point of Sales in Sales Weekly base, but when I use slicer the typology disappears and in post of them get out the number of weeks.
The two dashboards are connected with the same slice.
Sorry bur I can share data, because is not allowed from my company.
I hope to give me a solution.
Best regards,
Fatjon
Fatjon
Posted : 17/05/2020 5:53 pm
Hi Fatjon,
It's very difficult to help you without seeing at least screenshots, which you can anonymize before sharing.
You haven't said what the fields are in these PivotTables or what field the Slicer uses. I wonder if the Slicer is a Month field or week field, so when you apply the filter it has no choice but to filter all PivotTables it's connected to by that level of granularity.
You really need to provide visual information for us to help you further. Please use some image editing tools like Paint to remove sensitive data from the image before sharing.
Mynda
Posted : 18/05/2020 7:30 am
