Forum Discussion
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...
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
I am having trouble connecting my slicer to my pivot tables via Report Connections which are greyed out?
When i select them nothing happens? They all are from the data model? What am i doing wrong?
