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 Championthere are several maps in power bi, which one are you using? also what you have plotted, please provie more information.
Hello, The map type used is just the regular map of powerbi
and i'm plotting the sales Measure depending on regions!
- vanessafvg
there 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