Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
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.?
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.
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: