Forum Discussion
ECE
6 years agoAdvocate II
Userelationship and interaction between visuals
Hi, I have two graphs which shows the Sales Order Values (SO V), gruped by different dates (Created Date and Requested Date, both linked to my DataTable). I use the "UseRelationShip" function to ...
MFelix
6 years agoSuper User
HI ECE ,
Create a duplicate of the calendar table and make an active relationship between this table and the requested date now use this table as the x-axis on the graphs were you want to have the requested calculations.
No need to use the Requested Measure on your data except when you want to compare requested and created on the shame chart.
Check PBIX file attach, chart 1 and 2 workihng as the 2 bottom ones.