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
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
