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.
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
@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")
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 |
---|---|
112 | |
97 | |
83 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |