Forum Discussion

schapholkar's avatar
schapholkar
New Member
2 years ago

Slicer , Tile

I have a slicer Tile Style. I am using it to select countries. in the table there are many more countries then the list I am showing here. 

when I click on Select All - I assumed it will show the result from all the countries that I am displaying in Tile but it shows all the countries from table.

To resolve this I made a table in which I added all the countries those I wanted as per below. then I created Tile Slicer using the column of that table. then I created relation ship between original country table and my new table .

original table (country )one to one new table (country). 

Still when I click on select all it shows data of all other countries from original table. How can I resolve this?

Country Name

ARE
BHR
EGY
ITA
IND
KWT
OMN
PSE
SAU
ZAF

 

Show and Tell

5 Replies

  • Bmejia's avatar
    Bmejia
    Super User
    2 years ago

    I would check and make sure that you do not have visual filters on the slicer.  If you need to exclude certain countries and be able to see the same filters being implemented in the slicer and graphs and tables then you would need to add to the them in the page filter or on all pages.   Also it is posssilble that you could have measures that ignore the filter content.

    For example:

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi schapholkar ,

     

    I would like to acknowledge the valuable input provided by the Bmejia . His initial ideas were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the issue.

     

    In my investigation, I took the following steps:

     

    Like you described in the topic, I created a table with 20 countries and a table with 10 countries.

     

    I created a measure to check if the country/region from the original table exists in the new table.

     

    Is SelectedCountry = IF(
    ISBLANK(RELATED('Country'[Country Name])),
    FALSE(),
    TRUE()
)

     

     

    Use this measure as a page-level Filter and select it as True.

     

    The effect of the page before applying the Filter is as follows:

     

    The effect of the page after applying the Filter is as follows:

     

    The pbix file is attached.

     

    If you have any other queries please feel free to contact me.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    • schapholkar's avatar
      schapholkar
      New Member
      2 years ago

      Hi 

      Many thanks for your quick reply -

      I have done exactly as per your advice  -

      1. below is my model view 

       

      Relationship created

      It is not allowing to commit due to below error

       

      I dont understand why it is showing. I checked complete spelling 

      It is not allowing me to make this new selectedcountry column.

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi schapholkar ,

         

        In Power BI Desktop model view, you can interpret a relationship as being limited. A limited relationship is represented with parenthesis-like marks ( ) after the cardinality indicators.

         

        There are other restrictions related to limited relationships:

         

        The RELATED DAX function can not be used to retrieve the "one" side column values.

         

        Enforcing RLS has topology restrictions.

         

        For more on this, please see:

        Model relationships in Power BI Desktop - Power BI | Microsoft Learn

         

        Please make the appropriate changes according to the official documentation provided.

         

        Here is a view of my model:

         

        If you have any other questions please feel free to contact me.

         

        Best Regards,
        Yang
        Community Support Team

         

        If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
        If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!