Forum Discussion

tex628's avatar
tex628
Community Champion
8 years ago
Solved

Conditional formatting

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 formatti...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    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

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

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's avatar
tex628
Community Champion
8 years ago

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

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    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's avatar
      tex628
      Community Champion
      8 years ago

      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