Forum Discussion
Single Date Range Slicer For Two Tables
Hello,
I have two columns from two different tables in a bar graph. Both of these tables have a column for the dates that correlate to the two values in that bar graph. When I make a 'Between' sliding slicer from one of the date columns in one of my tables, it wrongly effects the other tables values in my bar graph. Is there a way to have a bar graph with data from two seperate tables (both with different date colmns) and a slicer that changes the bar graph bessed off of both tables dates?
Yes. Create a date dimension table with a relationship to both existing tables.
Similar situation here:
https://community.fabric.microsoft.com/t5/Desktop/Same-Dimensions-multiple-Fact-tables-different-measures-millions/td-p/3212805
2 Replies
Yes. Create a date dimension table with a relationship to both existing tables.
Similar situation here:
https://community.fabric.microsoft.com/t5/Desktop/Same-Dimensions-multiple-Fact-tables-different-measures-millions/td-p/3212805This worked, thank you!
