Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
To preface, I cannot do a bi-directional relationship between these two data sets due to model complexity so do not suggest that.
I have a date table and a data set.
The data set is composed of columns [Client], [Date], [Measure]. I have a slicer on [Client].
Not all clients have measures on all dates, i.e. one may have measures for July 16 to July 17, while another may have measures from June 14 to July 17. I want to be able to filter a date slicer so that the client that only has measures for July 16 and onwards will only show a timeline for July 16 to July 17 on the slicer, rather than show June 14 to July 17 for any selected client despite a lack of data.
To do so, I created a calculated column in my date table. The calculation is =IF(`date table`[date] IN VALUES(`data set`[date]), [date], BLANK())
I expected my [Client] slicer to filter down the `data set` table, and then the calculated column would display BLANK() for all the dates in the date table not observed for the chosen [Client]. That did not happen. The calculated column is ignoring the [Client] slicer entirely.
How do I fix this?
Solved! Go to Solution.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |