Forum Discussion
Show Inverse Options to Slicer
Hi Dramus
Thanks for your reply.
That solution had crossed my mind using some kind of toggle slider to act as the link between bookmarks but I was just wondering if it's possible to achieve similar results by having an inversely filtered second slicer.
I've used the bookmarks solution and it seemed to be working well. However, I've run into a problem.
I followed the instructions on the sqlbi website about filtering and comparing different time periods. I have a separate dates table and my student appointments data table (which contains a date column). The date slicers correspond to these two date columns which have an inactive relationship. The issue is that the appointments aren't showing up in the bar chart or table even though they are being counted in the card at the top and the table total.
There are 31 Manchester appointments as you can see from the Excel data in the below image that are accounted for in the table total and card but not the rows of the table or bars of the chart.
The measure I'm using is:
Previous Appointments =
CALCULATE (
COUNT(Sheet1[Type]),
ALL(Sheet1[Date]),
USERELATIONSHIP('Dates'[Date], Sheet1[Date])
)
This seems to be the issue but I can't work out why.
Can anyone help?