Forum Discussion
PowerBI Map View Filtered along side with Unfiltred Data
Hi AmineGatou ,
You will need to create an indenpenet slicer table like below:
slicer = distinct('table'[locations])
Then create a measure like below and add it to conditional formatting value.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
Measure = IF(SELECTEDVALUE('Table'[location]) in VALUES('slicer'[location]),"red","green")
Best Regards,
Jay
Hi AmineGatou ,
If you have other slicers, add the filter conditions to the measure.
Measure = IF(SELECTEDVALUE('Table'[location]) in VALUES('slicer'[location]&&'table'[column] in Values('slicer2'[column])),"red","green")
Best Regards,
Jay
Community Championyou need to probably change your edit interactions and set it to the no filter
once you have selected edit interactions, there will be some filters show top right of every object, then click on the slicer object first, then on your map select no filter
ie
more information here
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
This does help but it isn't what I'm looking for.
What I mean is that I want my map to be filtered but just to grey out the unfiltered data just like this .
Hello did you get the solution ? because i have the same problem here
Unfortunately, i couldn't find a solution to it. Still waiting.