Forum Discussion

Cheng2202's avatar
Cheng2202
Frequent Visitor
2 years ago
Solved

Conditional format on matrix table

I want to make an icon conditional format on a matrix table but I have som issues. I can just make conditional format based on one column but I want it to compare with another one. I also just want t...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Your solution is great, johnbasha33 . It worked like a charm!

    Hi, Cheng2202 

    Have you already solved the current problem? I tried the workaround of johnbasha33 using the following sample data and it worked

    I have the following table visual, and then I create one measure using the following DAX expression:

    icon color = 
SWITCH(TRUE(),
[Profit]*0.1>=[Input],"green",
[Profit]>0&&[Profit]*0.1<[Input],"yellow",
"red")

    Set the conditional formatting as follows:

    Here are the results:

     

    How to Get Your Question Answered Quickly

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

    Best Regards

    Jianpeng Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Your solution is great, johnbasha33 . It worked like a charm!

Hi, Cheng2202 

Have you already solved the current problem? I tried the workaround of johnbasha33 using the following sample data and it worked

I have the following table visual, and then I create one measure using the following DAX expression:

icon color = 
SWITCH(TRUE(),
[Profit]*0.1>=[Input],"green",
[Profit]>0&&[Profit]*0.1<[Input],"yellow",
"red")

Set the conditional formatting as follows:

Here are the results:

 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Cheng2202's avatar
    Cheng2202
    Frequent Visitor
    2 years ago

    johnbasha33 Anonymous 

    Thanks for your help and sorry for late reply! Had much to do lately.

     

    I encountered a problem with the measure. On "SELECTEDVALUE('YourTable'[Totalt])" and "SELECTEDVALUE('YourTable'[Budsjett])" I can't fill in as those numbers are from another measure and not in the table. The measure for..

     

    ..Totalt is:

     

    ..Budsjett is:

     

    Do you have any solution for this? ğŸ˜Š

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi, Cheng2202 

      Thank you very much for your reply. If you're two measures, then your DAX expression looks like this:

      icon color = 
SWITCH(TRUE(),
[Totalt]>[Budsjett]*0.1,"green",
[Totalt]>0&&[Totalt]<=[Budsjett]*0.1,"yellow",
"red")

      Then you need to put these three measures in the matrix table and conditionally format the icon color.

       

       

      How to Get Your Question Answered Quickly

      If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

      Best Regards

      Jianpeng Li

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • Cheng2202's avatar
        Cheng2202
        Frequent Visitor
        2 years ago

        Anonymous Is it possible to remove where it says yellow? ğŸ¤”