Forum Discussion
Conditional format on matrix table
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.
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.
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? 😊