Forum Discussion

netnai's avatar
netnai
Regular Visitor
7 years ago
Solved

Conditional Formating with info from different origins

Really new to Power BI, sorry if this is an already discussed question.

 

I have two queries from differents DB's as follows:

 

Q1 - Values:

00:62

01:62

06:52

... and more

 

Q2 - Values

00:62

01:62

06:52

and nothing else.

 

I want a bar chart for Q1 with different color for every record that only exists in Q2.

 

I tried a conditional formating with a measure:

 

ColorChange = SWITCH(TRUE;SUM('Q1'[Counter])>6000;"#FF0000";"#01B8AA")

 

But it is not exactly what I need.

 

As you can see in the attachment, those red bars appear together but could be scattered sometimes.

 

Thanks for your interest!