Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |