Conditional Formating within 2 different queries

Question

Greetings,&nbsp;I have 2 columns in data table in power BI from different tables .Available StockOrdered Quantity&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;I want to use the conditional formatting for the following.If Ordered Quantity is more then Available stock then No&nbsp;If Else Yes.to be returned back .&nbsp;I tried merging but it is not of use because there are similar material numbers .

arul · Answer

Yashh&nbsp;,
Could you share the sample data?
Thanks,
Arul

yashh · Answer

Arul&nbsp;&nbsp;First Query which contains material number and available quantity&nbsp;&nbsp;Second query which contains the ordered quantity. But here you can see there are material repeated so we cannot use the merge option.

Forum Discussion

Conditional Formating within 2 different queries

2 Replies

Related content

Conditional Formatting

Conditional Formatting using DAX

Conditional formatting for difference between bars?

Conditional Formatting

Matrix Row Conditional Formatting