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"

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

You lost me. What needs changing?

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"