Conditional column didn't works

[Anonymous]

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

[v-yingjl]

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.

[lbendlin]

have you addressed the issue with the null values?

[Anonymous]

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

[lbendlin]

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]

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]

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