Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Conditional column didn't works

Dear expert

 

I try to set up Conditional column but it didn't shows on all the column. Most of the column shows "Error" and didn't works for some reason. I did set up exactly same condition on another Power BI report and it works fine but not for this particular power bi report i am working now. All the screenshot attached as below.

 

Power BI Conditional Column (1).docx

 

Appreciate for your time and help, hopefully can hear from you soon.

 

Thank you

Maggie

Need Help

6 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    either your discounts or style price columns are empty ("null") - You need to convert the nulls to some value, or use the advanced editor to change your conditional rules to account for nulls.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks for the reply. 

      I figure out the reason why it didn't works. The spreedsheet i am working on was combined two excel spreedsheet and only one of the spreedsheet the condition column is working and the other half of the spreedsheet the column didn't works.

       

      Do you know how to solve this issue?

       

      Please advise, thank you

       

      Maggie

      • Jimmy801's avatar
        Jimmy801
        Community Champion
        5 years ago

        Hello Anonymous 

         

        without any additional information it's impossible to say why your combined dataset is not working.

        Maybe before you are combining them you select only specific columns and then this data is missing for your conditional formula. Maybe in some sheet its text on another is a number. Can you share your query and post some screenshots?

         

        If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
        Kudoes are nice too

        Have fun

        Jimmy

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I think the null values is ok becuase those are negative and not the criteria that i am looking at ( those won't take it into account anyway.) 

      Regarding to the append queries of spreedsheets, do you have any idea why it works for half of them but didn't works for all? 

      Thank you

  • v-yingjl's avatar
    v-yingjl
    Community Support
    5 years ago

    Hi Anonymous ,

    Based on my test, seems could not reproduce it in my side, I can create a conditional column based on your sample data:

    Maybe you can try to change the data type of [Style Price] column to check it again.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.