Using a dimension to highlight data across a report using several fact tables

[Guido_Beulen]

Hello all, 

I have a interesting challenge. I have a Location dimension with buildings we're servicing. These buildings each have one Area Manager, but an Area Manager has several locations. My fact table data are linked to the locations (varying names, I am affraid, so several columns in the DIM).

What I want to do is highlight the 'part of the data' that is linked to that particular Area Manager. This can be coloring specific (rows) data in a normal table, highlighting a part of a Bar, or adding a line for service level development in a line chart (where the other line of lines would be 'dimmed' or 'greyed out'). What would be the best way to do this? I have a measure for SELECTEDVALUE([Area Manager]), but how would I apply this succesfully to all those visuals. If possible I would even like to be able to select other regions/Area's as well for comparison in for example the line or bar chart. 

  Best regards, Guido

[amitchandak]

@Guido_Beulen , Not very clear, But you can create a measure based on SELECTEDVALUE([Area Manager]), and use that in conditional formatting

example

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...

Colour =
SWITCH(TRUE(),
SELECTEDVALUE('Table'[Month Year]) = "Jan-2020", "red",
SELECTEDVALUE('Table'[Month Year]) < "Feb-2020", "orange",
//keep on adding
"green")