Forum Discussion
Waterfall chart based on Two tables
Yes, you have 2 options either you can follow the below link and use the DAX USERELATIONSHIP and use an in-active relationship.
https://www.sqlbi.com/articles/using-userelationship-in-dax/
Or create a separate table with unique ids from both the tables as i mentioned previously.
For the optimization use the Filtering direction to a single side instead of both sides.
IF MY SOLUTION HELPED YOU PLEASE DO HIT A LIKE AND ACCEPT IT AS A SOLUTION IF IT SOLVES YOUR ERROR!
Regards,
Nimai Ahluwalia
Hello NimaiAhluwalia ,
Yes I know that but I already have realtionship with date table to which I have make relationship of all the tables. We cannot have active relationship one for date and one for ID column I guess. Is there any other solution that we can keep Date relationship among both the table as well as get the ID based waterfall chart?
Yes, you have 2 options either you can follow the below link and use the DAX USERELATIONSHIP and use an in-active relationship.
https://www.sqlbi.com/articles/using-userelationship-in-dax/
Or create a separate table with unique ids from both the tables as i mentioned previously.
For the optimization use the Filtering direction to a single side instead of both sides.
IF MY SOLUTION HELPED YOU PLEASE DO HIT A LIKE AND ACCEPT IT AS A SOLUTION IF IT SOLVES YOUR ERROR!
Regards,
Nimai Ahluwalia
Hello NimaiAhluwalia ,
I have managed to add a Bridge Table but its value is repeating in water fall chart once for planned and once for actual
you can use
Table = DISTINCT(UNION(VALUES(Sheet1[ID]),VALUES(Sheet2[ID])))