Forum Discussion
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!
netnai ,
You may check if the link below helps.
https://www.sqlbi.com/articles/from-sql-to-dax-in-and-exists/
1 Reply
- v-chuncz-msftCommunity Support
netnai ,
You may check if the link below helps.
https://www.sqlbi.com/articles/from-sql-to-dax-in-and-exists/