Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a Matrix table that shows Inventory turnover for each Vendor.
I want to know If I have different conditions for each Vendor.
For Ex if the value or Vendor1 >= 300 then use orange but for Vendor2 use Green
If the value goes below 100 for Vendor 4 then use red but do not apply the same rule for other vendors.
Let me know if this is possible
Solved! Go to Solution.
I have uploaded a test .pbix file that are working.
Does not look like I have possibilites to upload the file. If needed, I can email it to you. Please let me know.
My measure looks like this: (Could you try to change yours as well, and use AND () instead of &.
Br
Marius
This is the measure I created.
It is located under the main table.
What do you mean by "put the measure in the matrix"?
In the table/matrix where you gonna have the conditional formatting, put the color measure in the value field. Just to ensure its not throwing a error measure.
This is for debugging purpose only
This is the error I got
"Calculation error in measure 'npa_invtry_qty'[Color measure]: DAX comparison operations do not support comparing values of type True/False with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values."
This is my DAX
I have uploaded a test .pbix file that are working.
Does not look like I have possibilites to upload the file. If needed, I can email it to you. Please let me know.
My measure looks like this: (Could you try to change yours as well, and use AND () instead of &.
Br
Marius
You are a genius.
it is working now
please email it to sramaswamy71@gmail.com
I have now emailed you the working .pbix file as agreed 🙂
Br
Marius
Hi,
You can create a measure to be used with conditional formatting;
Color measure =
SWITCH ( TRUE(),
SELECTEDVALUE (Table[In charge]) = "Vendor1" & SUM(Table[ValueColumn]) >= 300, "#F3F2F1",
SELECTEDVALUE (Table[In charge]) = "Vendor2" & SUM(Table[ValueColumn]) >= 200, "#666666"
)
Br
Marius
Thanks for reply.
How will the measure be applied after we create it?
Hi again,
When you are in the conditional formatting pane you need to choose field value in the format style:
Marius
I tried that and it is not letting me choose the measure as an option
After I click on Color Measure
Can you put the measure in the Matrix and ensure there is no error in it? When I have the issue of choosing measure in the field value its because the measure has error in it
Marius
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |