Forum Discussion
Ericwhv
Helper II
Helper IIPower BI - Dax (Funnel)
Hi Everyone appreciate for your help in advance. i am building a dashboard to show the most recent shipment details for below table, if i would like to show the HOUSE in red on the dashboard, h...
Add the measure to the visual filters and set it to "red"
lbendlin
Super User
Super UserNot sure if I captured the logic behind your rules.
Font Color =
var b = CALCULATETABLE('Table',ALLEXCEPT('Table','Table'[House]))
var l = countrows(filter(b,'Table'[LegCheck]="Last Leg"))
var c = countrows(filter(b,isblank('Table'[COB])))
return
switch(TRUE()
,max('Table'[LegCheck])="Last Leg" && l>0,"red"
,isblank(max('Table'[COB])) && c >0,"red"
,l=0 && c=0 && max('Table'[COB])=maxx(b,[COB]),"red"
,"black")
see attached
EricwhvHelper II
Helper IIHi #lbendlin
Thank you for your reply
the logic is right!
if it could change it from the "Colour" to the HB#?
the result I hope is....
House | Master | Consol Lane | Movement Lane | GNR Origin | GNR Dest | LegCheck | ArrivalCheck | COB |
| 412647 | CPHT0071 | CPH-STO | JHB-STO | AMS | STO | Last Leg | Not Arrived | |
| 415828 | LHRT0640 | LHR-FRA | BFS-GRU | BFS | FRA | Transit Leg | Not Arrived, Missing Last Leg | |
| 414467 | LHRT0639 | LHR-BRS | NGB-BHX | AMS | BHX | Transit Leg | Not Arrived, Missing last leg | 21/04/2022 02:24 |
Thank you for your help!!
- lbendlin
You lost me. What needs changing?
- Ericwhv
switch(TRUE() ,max('Table'[LegCheck])="Last Leg" && l>0,"red" ,isblank(max('Table'[COB])) && c >0,"red" ,l=0 && c=0 && max('Table'[COB])=maxx(b,[COB]),"red" ,"black")This part, if "Red" change it to the House#?
the "black" is the House#, i dont want to show it in there.
(just want to avoid using the filter, lol)
thank you
- lbendlin
Instead of using the measure for conditional formatting you want to apply it as a filter for the visual?