Forum Discussion

seankoh's avatar
seankoh
Frequent Visitor
8 years ago
Solved

Filter chart based on slicer selection

Hi all,   I have 5 tables which corresponds to 5 different locations (Site 1 - Site 5), each showing the number of cars, bikes and large vehicles on an hourly basis. These 5 tables are linked to an...
  • Rfranca's avatar
    Rfranca
    8 years ago

    Hi, Sean

    The combination of the five tables results in a NEW table similar to the existing ones. Instead of selecting information from the five tables, you will select and create your filters and measures from this consolidated table.

    Do not forget that all five tables should have the same layout, otherwise it will not work correctly.


    But notice this:
    1. To consolidate each location table, you must have a column that identifies its location. If it does not exist you must create a column with this ID.

    2. When you consolidate, use the option to create a new table, to facilitate understanding.

    3. And after consolidating use this new table to create your controls and measures, and the filter also comes from this new table.

    See the sequence of images ...

     

    Please try and test using it. And please mark the right answer as answer if your issue has been resolved, otherwise, please feel free to ask if you have any other issue.

     

    Best Regards,

    Rfranca

     

     

seankoh's avatar
seankoh
Frequent Visitor
8 years ago

Hi Rfranca,

 

1. If I combine the 5 tables into 1, how would I then select the different locations to display? Where would the values for my location slicer come from, since the data for all the different locations are now in one table?


2. Can you further elaborate on 'sum of the quantities of the five tables'?

 

Thanks.

 

Best regards,

Sean

Rfranca's avatar
Rfranca
Resolver IV
8 years ago

Hi, Sean

The combination of the five tables results in a NEW table similar to the existing ones. Instead of selecting information from the five tables, you will select and create your filters and measures from this consolidated table.

Do not forget that all five tables should have the same layout, otherwise it will not work correctly.


But notice this:
1. To consolidate each location table, you must have a column that identifies its location. If it does not exist you must create a column with this ID.

2. When you consolidate, use the option to create a new table, to facilitate understanding.

3. And after consolidating use this new table to create your controls and measures, and the filter also comes from this new table.

See the sequence of images ...

 

Please try and test using it. And please mark the right answer as answer if your issue has been resolved, otherwise, please feel free to ask if you have any other issue.

 

Best Regards,

Rfranca