Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Conditional Formatting Matrix with DAX

I created this matrix that almost looks like I want but I am having trouble with the conditional formatting. I am trying to use conditional formatting to change the 'Due Date' to be transparent at t...
  • Moetazzahran's avatar
    Moetazzahran
    2 years ago

    Hello, 

    I imagine that if you use a

    HASONEVALUE('Table'[UI_Description])||ISBLANK(SELECTEDVALUE('Table'[UI_Description])) condition in your measure, it should work properly. 
    I tested this measure and it worked properly for me. 

    Measure = SWITCH(TRUE(),
        HASONEVALUE('Table'[UI_Description])||ISBLANK(SELECTEDVALUE('Table'[UI_Description])),
            "#FFFFFF00",
        "#000000" )

    Thank you. If you think this solution helped, please accept it as a solution and your kudos will be much appreciated!


Moetazzahran's avatar
Moetazzahran
Resolver II
2 years ago

Hello, 

I imagine that if you use a

HASONEVALUE('Table'[UI_Description])||ISBLANK(SELECTEDVALUE('Table'[UI_Description])) condition in your measure, it should work properly. 
I tested this measure and it worked properly for me. 

Measure = SWITCH(TRUE(),
    HASONEVALUE('Table'[UI_Description])||ISBLANK(SELECTEDVALUE('Table'[UI_Description])),
        "#FFFFFF00",
    "#000000" )

Thank you. If you think this solution helped, please accept it as a solution and your kudos will be much appreciated!