Active Member
Dashboards
August 1, 2017
my manager asked me to design a dashboard consists of charts for diseases , evaluation of the disease (evaluated ,not evaluated),contacting the patients (contacted or not contacted),referral to second opinion(Referred or not referred) , Medication names and connect them all by (Month , provider areas & Age of patients)
I use slicers for Month ,Provider areas & Age to connect them all but she asked to connect them using different developers
I managed to connect them all using list box for month but I could not continue to connect those charts again with age & Areas
e.g filter charts by January then take this filtered charts to further filter by western region
is it possible
July 16, 2010
Hi Ahmed,
Connect them using different developers? Do you have a column in your source data that classifies each row by Developer? If so you can use a Slicer for this as well.
If not then you can either add a column for the Developer, or use Power Pivot to create a relationship between your transactional data and the developer and use Power Pivot PivotTables and Slicers. The latter is a bit difficult to describe here.
If you're able to share a sample Excel file and more details on how you know what 'Developer' goes with each row of data then we can help you further.
Mynda
1 Guest(s)