Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
can anyone help me on this one. I am trying to highlight the payments values according to certain costs. My table contains payments for different departments each has a different price. School fees and Bus fees for example.
I could do that if I filter out the table to School fees only or Bus fees only in two seperate table visuals. How can I do that in just one table combining both?
Solved! Go to Solution.
Hi @MiriamMattar , please try the following measures, don't forget to modify the amount data in IF statements.
Sum Payment = SUM ( Payments[Payments] )
KPI BG+SG 2 =
VAR __service = SELECTEDVALUE ( Payments[Service] )
VAR __payment = [Sum Payment]
RETURN
SWITCH (
__service,
"School-fees",
IF (
__payment >= 30,
"#008000",
IF (
__payment >= 20 && __payment < 30,
"#ffa500",
IF ( __payment < 20, "#ff0003" )
)
),
"Bus-fees",
IF (
__payment >= 300,
"#008000",
IF (
__payment >= 200 && __payment < 300,
"#ffa500",
IF ( __payment < 200, "#ff0003" )
)
)
)
Test result:
Best Regards,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
Hi @MiriamMattar , please try the following measures, don't forget to modify the amount data in IF statements.
Sum Payment = SUM ( Payments[Payments] )
KPI BG+SG 2 =
VAR __service = SELECTEDVALUE ( Payments[Service] )
VAR __payment = [Sum Payment]
RETURN
SWITCH (
__service,
"School-fees",
IF (
__payment >= 30,
"#008000",
IF (
__payment >= 20 && __payment < 30,
"#ffa500",
IF ( __payment < 20, "#ff0003" )
)
),
"Bus-fees",
IF (
__payment >= 300,
"#008000",
IF (
__payment >= 200 && __payment < 300,
"#ffa500",
IF ( __payment < 200, "#ff0003" )
)
)
)
Test result:
Best Regards,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
@MiriamMattar , Have a condition on bus and school fee so that those conditions are reachable
Also, use Switch True(), like
Switch(True() ,
[Service] ="Bus Fee" , Switch(True() ,
_sch_fee <=30000, "#ff00ff",
//condition 2,
//condition 3,
//else
),
[Service] ="School Fee" , Switch(True() ,
_sch_fee <=30000, "#ff00ff",
//condition 2,
//condition 3,
//else
)
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |