Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a filter containing City/Country :
I created a table Filters with a column Filtering containing City and Country like above.
When selecting City I want to display the target by city:
When selecting Country I want to display the target by country:
Knowing that I have other filters in the same page like semester ...
Solved! Go to Solution.
Hi @amirabedhiafi ,
Here are the steps you can follow:
1. Use Enter data to create a table.
2. Create measure.
City =
IF(
CONTAINS(
'Table',
'Table'[Slicer Selection],"City"),
SUMX(FILTER('Filters','Filters'[City]=MAX('Filters'[City])),'Filters'[Target]),BLANK())
Country =
IF(
CONTAINS(
'Table',
'Table'[Slicer Selection],"Country"), SUMX(FILTER('Filters','Filters'[City]=MAX('Filters'[City])&&'Filters'[Country]=MAX('Filters'[Country])),'Filters'[Target]),BLANK())
3. Use Table's [Slicer Selection] as the slicer
4. Result:
When choosing City as:
When choosing Country as:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @amirabedhiafi ,
Here are the steps you can follow:
1. Use Enter data to create a table.
2. Create measure.
City =
IF(
CONTAINS(
'Table',
'Table'[Slicer Selection],"City"),
SUMX(FILTER('Filters','Filters'[City]=MAX('Filters'[City])),'Filters'[Target]),BLANK())
Country =
IF(
CONTAINS(
'Table',
'Table'[Slicer Selection],"Country"), SUMX(FILTER('Filters','Filters'[City]=MAX('Filters'[City])&&'Filters'[Country]=MAX('Filters'[Country])),'Filters'[Target]),BLANK())
3. Use Table's [Slicer Selection] as the slicer
4. Result:
When choosing City as:
When choosing Country as:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Do you know how to use bookmarks? I would recommend it.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Yes just tried to use a trick with the filters instead of the bookmarks.
Well try with Bookmarks now,
Put 2 visuals on top of each others, select the filter, and depending on filter selection hide or keep the visual you need to see using bookmarks.
here is a video that could help you
https://www.youtube.com/watch?v=_Afcj8mT5_Q
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |