Forum Discussion

Ericwhv's avatar
Ericwhv
Icon for Helper II rankHelper II
4 years ago
Solved

Power 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...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    Add the measure to the visual filters and set it to "red"

Ericwhv's avatar
Ericwhv
Icon for Helper II rankHelper II
4 years ago
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's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Instead of using the measure for conditional formatting you want to apply it as a filter for the visual?

  • Ericwhv's avatar
    Ericwhv
    Icon for Helper II rankHelper II
    4 years ago

    Yes

    in deed, i am not changing the colour but want to show the result in the visual, thankyou

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      4 years ago

      Add the measure to the visual filters and set it to "red"

      • Ericwhv's avatar
        Ericwhv
        Icon for Helper II rankHelper II
        4 years ago

        Thank you Ibendlin!
        yes, that is one of the way to solve my problem, thank you!!