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
Hello, The map type used is just the regular map of powerbi
and i'm plotting the sales Measure depending on regions!
Community Championthere is no regular one, which one are you using, in order for help to be given, you need to give the details.
Here is the one used
- vanessafvg
you 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 .