Conditional Formatting at Row Level on Matrix

[augustindelaf]

Hi

Currently, Conditional formatting is very poor on visuals for Power BI.

To do conditional formatting on matrix, possibilities are weak because I use pivoted data (Attribute, Value)

Attributes can be "K. Visco@C" or "BN" , and Values are all pivoted data

So, we have to create several matrix visuals for each row and then we need to put them under each one. (screenshot)

It could be good to have more specific conditional formatting that acts row by row !

Do you know how I can do it ?

Thanks

[v-easonf-msft]

Hi , @augustindelaf 

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or add your reply as Answered to close this thread?

Best Regards,
Community Support Team _ Eason

[augustindelaf]

Hi
Not solved

[amitchandak]

Not very clear. Can you explain bit more

[augustindelaf]

Hi again @amitchandak 

In my matrix, each attribute has a row.

My Conditional formatting must be specific for each attribute.

i.e :

-for 'BN', turn orange if value is between 10 and 15, and red if value < 10.

-for 'Iron', turn orange if value > 100 and red if value >200

-for 'Chromium', turn orange if value > 600

All these attributes have their own rules, and I would like to have one single Matrix that enables me to manage conditional formatting of each row.

But not possible 

Then, the solution that I envisionned is to create one matrix for each attribute, and then I am able to set the conditional formatting. (see screenshot, example for 'BN').

My only problem is that it becomes ugly when I export the report as PDF because Matrix visuals are never well aligned as if it was one single Matrix. It would also be more convenient to have one single Matrix.

Is it clear now ?

[amitchandak]

Try to create a measure like this

Color Date = if(FIRSTNONBLANK('Date'[date],TODAY()) <today(),"lightgreen","red")

As you will display the dim, the firstnonblank will give that value. You should able to add multiple conditions. Use Switch true, if needed

Now in the above UI, use field option and choose this measure.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin

[augustindelaf]

Hi @amitchandak

Sorry but the solution is not very clear either.

Please, could you provide me with an example, or a sample file ?

Many thanks in advance

BR

Augustin

[amitchandak]

This is an overloaded file.  Refer page 3 and Search for measure "Color Date"

https://www.dropbox.com/s/unfqa025ca7p3vw/CompareRange_timedim.pbix?dl=0

[augustindelaf]

Thanks.

Could you draw the measure with Switch with BN and Iron please ?

As a reminder :

-for 'BN', turn orange if value is between 10 and 15, and red if value < 10.

-for 'Iron', turn orange if value > 100 and red if value >200

-for 'Chromium', turn orange if value > 600

Then I would be able to do it with other attributes and I could mark you answer as Solution.

Best regards,

Augustin

[augustindelaf]

@MSFT_JT @sammicrosoft @MicrosoftADE @rickmicrosoft