Forum Discussion

LUCASM's avatar
LUCASM
Helper IV
1 year ago

Conditional formatting

I am trying to set a formatting rule where, IF my product value is < the selected product value then Background colour = PINK, if My Product value > the selected product value then Background colour ...
Need Help
danextian's avatar
danextian
Super User
1 year ago

Hi LUCASM 

 

Looking at your formula, both the selected product value and my_product are coming form the same table so when you select a product value from the slice, my_product also gets filtered to that specific product value.

Things you can do:

  • Change the slicer to a slider and select before - this will include every value up to the max slicer selection
  • Use a disconnected table by getting the distinct rows of 'Table'[Value].  Use this column in the slicer and change the change the Selected variable formula to MAX('Table'[Value])​

 

ValueTable = DISTINCT ( 'Table'[Value]  )

 

Note:  a disconnected table doens't have a relationship to your fact or dimension tables.

 

  • LUCASM's avatar
    LUCASM
    Helper IV
    1 year ago

    Caclulated Tables are not suppoprted in Power BI service.
    I had this and I needed to get rid of my Calculated table which is now causing my headache.
    Is there no way of ammending the 

    VAR My_Product = CALCULATE ( MAX ( 'Table'[Value] ) , 'Table'[Brand] = "My_Brand" )

    so it includes all brands and that my Filter then resets it to just my Brand?
    I tried using ALL but it doesnt appear to like that either.