Forum Discussion
Filter datacard by calendar table
My report has a slicer referencing a Calendar table. It works perfectly filtering the matrix table but it isn't filtering the datacard.
The thing that makes the filtering of the matrix work is a calcuated field that adds a 1 to records that fall inside the date range. I've called this field InDateRange.
Unfortunately, when I add this field to the filters for the datacard visualisation, it is locked from actually applying a filter to the InDateRange field.
Any suggestions on how I can make this work? Thanks
2 Replies
- amitchandak
Super User
kshirey , Based on what I got. Add some value in box below less than and they apply should be enabled
Also, make sure the slicer and car visual are interacting
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
Hi amitchandak
Thanks for your suggestion. The box below less than is locked for editing. This measure field works when filtering the table but it is locked when I add it as a filter to the datacard.
This is the main problem.
Also, the slicer and the card visual are interacting.
Hope you can help.
