Forum Discussion

verbani007's avatar
verbani007
Frequent Visitor
7 years ago

Filter Slicer

Hi,

 

I'm trying to make a comparing report with 2 slicers. The first slicer is a city. The second slicer is a list of surrounding cities (based upon the selection of the first)

I made this possible by creating dax measure the returns is a city is surrounding to a selected city. Then I used this measure to filter the second slicer. This works fine. 

 

Then I have several values that are linked to these slicers. Number of persons would be one of them. I'm using the card visual to show the number of people based upon the first slicer. And a second visual based upon the filtered slicer. And with this last one I have an issue. Although the slicer is filtered, the value showing is the value for all cities (not the values of the filtered cities in my second slicer.)

 

I can apply the filter to the card visual. (I can add him, but can't make a selection)

 

Any idea on how to make sure the card value is showing the figures for the filtered slicer, and nog all values...

 

Regards,

Need Help

4 Replies

  • dearwatson's avatar
    dearwatson
    Continued Contributor
    7 years ago

    Hi verbani

     

    we might need an example of the data and the measures to help with this one. 

     

    at a guess it sounds like the values are not being filtered by the second slicer because no selection is being made on the second slicer to enable the filter?  

     

    I'll try and work it out if you can supply an example?

     

    Cheers

    Greg

     

    • verbani007's avatar
      verbani007
      Frequent Visitor
      7 years ago

      I'll try to give an example:

       

      Cities: A, B, C, D, E, F, G

      City A is surrounded BY E and F

      City B is surrounded BY C, D and G

       

      So if I select in my first slicer city B, the second slicer will show C, D and G. (This works perfectly)

       

      But under the slicer there is also a card showing the number of people that are living in the city.

       

      Lets say that in total there are 2000 people living in all cities.

      B has 500 people living in it's city. 

      C has 100

      D has 150

      G has 200

       

      So setting the selection of the first slicer to B give me a value in the card of slicer 1 of 500

      Setting the first slicer will filter the second slicer to C, D and G. (that is correct)

      But the card value under the second slicer will show 2000, instead of that I would expect 100 + 150 + 200 or 450

       

      When I do a selection in the second slicer, the value in the second card is correct(!). But this is not the case when no selection is set in the second slicer.

      • v-diye-msft's avatar
        v-diye-msft
        Community Support
        7 years ago

        Hi verbani007 ,

         

        Would you mind sharing your dummy pbix? Make sure the confidential info has been removed before. 

         

        We'd like to provide further solution once got it.

         

        Best regards,

        Dina Ye