Forum Discussion

MichaelSX's avatar
MichaelSX
Frequent Visitor
8 years ago
Solved

Slicer to filter values from two different tables

I have a table with a project number and an expenditure column. I have another table with project number and time spent. I want to make a graph/chart that displays the cumulative total of the expendi...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi MichaelSX,

     

    You need to create a third table (projects) with unique values them make a relationship between this table and the other two then use this as your slicer to filter your charts.

     

    Be aware that you need to use this column to use as axisor values on your visuals.

     

    Check this link that explains what is needed to do.

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi MichaelSX,

 

You need to create a third table (projects) with unique values them make a relationship between this table and the other two then use this as your slicer to filter your charts.

 

Be aware that you need to use this column to use as axisor values on your visuals.

 

Check this link that explains what is needed to do.

 

Regards,

MFelix

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Is this necessary even if the other table is derived from an aggregation (summarize) from the first?

    • MFelix's avatar
      MFelix
      Icon for Super User rankSuper User
      7 years ago

      Hi Anonymous ,

       

      This is necessary if you have a the project number multiple times in each table if on one of the tables you have unique ID's you can create the relationship betwen the two tabls directly and then use the column with unique ID's for your slicer.

       

      Regards,

      MFelix