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"
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
Super User
Super UserYou 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