Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello!
I have a seemingly unsolvabe task i need help with.
I have a matrix visual that looks like this:
The values are calculated by a measure, hence the use of a matrix.
The column and row headers are from two different tables, but they are connected via additional tables.
I want to format the columns one by one so it highlights values that are below the individual "Target" values:
Is there a way to accomplish this?
I tried looking into solutions everywhere, but they are not even close to what i need.
Any help would be appreciated.
Thank you in andvance!
Solved! Go to Solution.
Hi @Benkov ,
Accroding to your screenshot, I think there should be at least [Group] columns in both tables. So I think you just need to calculate target in each group and compare [value measure] with the target in each group to get the color.
My Sample:
Relationship:
Measure:
Measure =
VAR _TRAGET = SUM('Column'[Target])
RETURN
IF([Value(Measure)]<_TRAGET,"Red")
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Benkov
You can apply conditional formatting based on value and that value is this measure:
99.80 is your target, you can put whatever you want , same for color I put red and black, but you can put there any color.
If([YourMeasure] < 99.80, "#F00", "#000")
Thank you for your reply!
As you can see on my previous pictures, i have multiple different values in my "Target" row, and your suggestion only works with one given value.
(there was some language barrier induced misunderstanding on my side)
As far as i know i cannot use it on individual columns in my matrix, because only one measure is allowed to fill the entire matrix with values without duplicating all cloumns.
Hi @Benkov ,
Accroding to your screenshot, I think there should be at least [Group] columns in both tables. So I think you just need to calculate target in each group and compare [value measure] with the target in each group to get the color.
My Sample:
Relationship:
Measure:
Measure =
VAR _TRAGET = SUM('Column'[Target])
RETURN
IF([Value(Measure)]<_TRAGET,"Red")
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
94 | |
79 | |
73 | |
63 | |
60 |
User | Count |
---|---|
108 | |
100 | |
77 | |
63 | |
61 |