The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi! I create a measure for change the color columns dynamically but it doesn't work. Below the measure:
ColorCol = SWITCH(TRUE(),
SELECTVALUE(TabProd[Product]) = "A", "Green"
SELECTVALUE(TabProd[Product]) = "B", "Yellow"
SELECTVALUE(TabProd[Product] = "C", "Red"
)
I don't know where is the mistake!
Solved! Go to Solution.
@DR2022 ,
It should work. Were you facing error in measure itself or it does not work on charts?
Thanks,
Arul
Hi, @DR2022
use SELECTEDVALUE, not SELECTVALUE (there is no such function)
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
261 | |
120 | |
113 | |
83 | |
71 |