Forum Discussion
One Visual Three Columns Dependent On Slicer
Hi, I have a table that has four fields. Customer (txt), Baseline (date), Target (date), Contract Value (decimal). I want to create a matrix that will have the following fields: - Customer ...
amitchandak
Super User
Super UserAnonymous , Join both Baseline and Target dates with same date table. One join will be inactive. Activate that using userelation .
Now they will filter on the same month.
refer example: https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
thank you for your response, but it doesn't work. My matrix with Customer, Baseline Value and Target Value is totally blank, no values, no rows.
Thank you for your response. However, I need these dates to be independent and will always be different (target WILL NOT equal baseline)... target can be June 2020, but baseline can be April 2020, so I am not sure if your solution will work in this scenario.