Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
schapholkar
New Member

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

 

5 REPLIES 5
v-huijiey-msft
Community Support
Community Support

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:

vhuijieymsft_0-1711089605242.png

 

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

vhuijieymsft_1-1711089605245.png

 

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!

Hi 

Many thanks for your quick reply -

I have done exactly as per your advice  -

1. below is my model view 

schapholkar_5-1711101724659.png

 

Relationship created

schapholkar_2-1711100048087.png

It is not allowing to commit due to below error

schapholkar_4-1711101634237.png

 

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

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

 

 

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:

vhuijieymsft_0-1711333074438.png

 

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!

Bmejia
Super User
Super User

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:

Bmejia_0-1711047140868.png

 

Hi ,

 

I have no filters on Slicer Visual

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.