Forum Discussion

Iain's avatar
Iain
Regular Visitor
8 years ago

Show Inverse Options to Slicer

Hello

 

I have a report which shows student appointments by location and by course in December 2016 and December 2017. I have a data table and another table where I’ve unpivoted the location and course columns. The chiclet slicer is then using the attribute as a slicer to filter the bar chart and table.

 

 

I was wondering if it would be possible to include another slicer or way of filtering the data which dynamically changes to show the inverse attribute. For example, if I click the course option in the chiclet slicer could I then show a slicer/table which contains the locations so I would be filtering by course and then by location, and vice versa?

 

I've searched through the forums but can't find a solution that quite works.

 

Thanks for any assistance.

Need Help

3 Replies

  • dramus's avatar
    dramus
    Continued Contributor
    8 years ago

    Could you use the new Bookmark feature to do this? Hiding visualizations as necessary?

    • Iain's avatar
      Iain
      Regular Visitor
      8 years ago

      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.

      • Iain's avatar
        Iain
        Regular Visitor
        8 years ago

        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?