Forum Discussion

bargok's avatar
bargok
New Member
8 years ago

Consolidating two slicers using similar columns

So I have two bar charts, one using the 'views_per_month' table and another using the 'views_per_day' table that are each being filtered by a 'year' column and being filtered using two seperate slice...
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi bargok,

 

If I understand your scenario correctly that you have tables and you create the two bar charts with the data from the two tables, you also create the two seperate slicers  to filter the the two chart with the same column?

 

And you want to create one single slicer to filter the two charts but there is no relationship for your two tables?

 

What about create another Calendar table with Canlendar function? Then you may create the relationship for the tables.

 

In addition, you could have a reference of this similar thread.

 

If you still need help, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

 

Best  Regards,

Cherry