Hi @kiuhgfkijHFIOuw
Welcome to the Microsoft Fabric Community Forum.
Regarding the issue with your color measure not working as expected in Power BI,while I’m not fully aware of the exact structure of your dataset, I’ve created a sample .pbix file to demonstrate one possible solution
The issue arises from the use of the AND() function inside a SWITCH(TRUE(), ...) statement. In DAX, while AND() returns a Boolean value, its use inside SWITCH(TRUE(), ...) can lead to unexpected behavior, especially when combining multiple conditions that evaluate values from a measure or column.
To resolve this, update DAX measure as follows:
ColorMeasure =
VAR Value = MAX(Rohdaten_E1[Pakete LZ nicht erreicht LZ E2E])
RETURN
SWITCH(
TRUE(),
Value <= 20, "#D3D3D3",
Value <= 50, "#FFDC00",
"#B40014"
)
I have attached a .PBIX, please take a moment to review them and see if this solution aligns with your requirements.
If this doesn’t fully meet your needs, could you kindly share a sample of your data and more detailed context? That would help us provide a more accurate solution. If you have any additional questions or require further assistance with implementing this measure in your visuals, please do not hesitate to follow up here.
If this response resolves your query, kindly mark it as Accepted Solution to help other community members. A Kudos is also appreciated if you found the response helpful.
Thank you!
