Forum Discussion

topazz11's avatar
topazz11
Helper III
6 years ago
Solved

Select values based on another slicer

 

Hello,

 

 

My probles is that 

1. I want show only the dates in current and prior based on the item selection (apple or grape).  

2. relationship can fix #1 but If I have a relationship between data table and Date Table, the variance measure doent work anymore.

 

I am sorry if I have been not be able to explain my question properly. Request you to kindly assist me with this and let me know if any additional information required.

 

Thanks,

 

here is pbix file.

PBIX example 

 

 

Expected outcomes: 

1. current and prior dates based on item selected.

2. correct variance.