Color code Issue, cell with no color

[FlavioMe3101]

I have a PowerBI with ‘Connect Live’ to an Analysis Service Server model that I need Conditional formatting the table that I generated.

I have a PowerBI with ‘Connect Live’ to an Analysis Service Server model.

One ‘matrix visual’ shows ‘Failure and failure Sub Bucket’ against Year-Month of failure. There are two date type data field- Step1 and Step2 taken for this failure, but all the failure don’t have these steps.

I have done colour coding as

1. if failure date > Step1 date - count will be highlighted in yellow
2. if failure date > step 2 date, count will be highlighted in red
3. If no failure after step 2 then green colour.

For the third condition, green is applied for all blanks/ zero count even if the ‘Failure and failure Sub Bucket’ doesn’t have Step 2 dates. I have tried to filtering this using Filter, SLECTEDVALUES etc in PowerBI dax. Also tried creating calculated columns in SSAS.

Is there any solution so that color coding is only applicable for blanks having step 2 dates.?

[lbendlin]

To report on things that are not there you need to use disconnected tables and/or crossjoins.  Most likely that's not something they let you do with this connection type.

[FlavioMe3101]

Do you have an idea how I can implement the color code that I need with "connect live", I am looking for something like this: