Forum Discussion
Solved
Waterfall chart based on Two tables
Hello, I have two tables and I want to have waterfall chart based on division by ID of both tables. Both the table share similar ID. Below are my tables: Date ID Volume 17/01/2022 AB-1 34...
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])))