Conditional formatting

[tex628]

Hello, I have a measure that I need to have conditional formatting applied on. But for some reason It does not respond to the formatting. Does anyone have any idea of the reason, and how the formatting can be applied?

Measure deliv = CALCULATE(SUMX('Delivery Q2';'TS Delivery Q2'[On Time])/sum('Delivery Q2'[Total # of order lines]))*100

Calc-value = IF(ISBLANK([Measure deliv]);0;
                    IF(0,2*[Measure deliv]-16<0;0;
                        IF('Delivery Q2'[Measure deliv]<85;0,2*[Measure deliv]-16;
                            IF([Measure deliv]<96;0,1818*[Measure deliv]-14,445;
                                IF([Measure deliv]-93>5;5;[Measure deliv]-93)
                                )
                             )
                          )
                       )

Calc value will return values between 0-5 and is the measure that i want to apply formatting to.

[v-yulgu-msft · Accepted solution]

Hi @tex628,

Based on my test, the returned value of [Calc-value] is changed dynamically depend on the actual value of [Measure deliv]. 

What do you mean " but the formatting doesn't work."? Please describe your scenario with sample data. Also, please show us what the correct result should be and what the incorrect result you have got.

Regards,

Yuliana Gu

[tex628]

What i meant was that the conditional formatting did not work. But i solved the issue, in my table i had a value incorrectly displayed as "First value" by removing the summarization the formatting started working 🙂

/ J

[Greg_Deckler]

When you say that it doesn't respond to formatting, are you saying that you don't get the option or that when you configure the formatting that it doesn't work?

[tex628]

I get the option, but the formatting doesn't work. 

[Greg_Deckler]

Which version of Power BI are you on? I just did this for a measure defined as below on the June 2018 version and it worked perfectly:

DiconnectedTableTrick = 
VAR __myVariable = 
SWITCH(
    MAX([Category]),
    "0-50 percent",1,
    "51-75 percent",2,
    "75-100 percent",3
)
RETURN __myVariable

[tex628]

Version: 2.59.5135.601 64-bit (juni 2018),

I dont know why it isnt working, i'm wondering if it has something to do with the data format but from what i can tell everything is formatted to numeric values.

/ Johannes