Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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 |
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!
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.
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!
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:
Hi ,
I have no filters on Slicer Visual
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
91 | |
87 | |
84 | |
68 | |
49 |
User | Count |
---|---|
131 | |
110 | |
96 | |
70 | |
67 |