Color code Issue, cell with no color

FlavioMe3101 — Wed, 01 May 2024 19:59:41 GMT

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

if failure date > Step1 date - count will be highlighted in yellow
if failure date > step 2 date, count will be highlighted in red
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.?

Re: Color code Issue, cell with no color

lbendlin — Wed, 01 May 2024 22:32:20 GMT

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.

Re: Color code Issue, cell with no color

FlavioMe3101 — Fri, 03 May 2024 13:33:39 GMT

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:

topic Re: Color code Issue, cell with no color in Custom Visuals Development Discussion

Color code Issue, cell with no color

Re: Color code Issue, cell with no color

Re: Color code Issue, cell with no color