Help - Conditional Formatting

[RENJITH_R_S]

Hello 

My sample data is

Status   Value   Pre/Post

A             1          Pre

A             2          Post

B             3          Pre

B           3          Post

C           6          Pre

C             7         Post

D             3          Pre

D        3          Post

my 2 visuals are

1. slicer 

Select All

Pre

Post

2. Table (when Pre is selected)

Status   Value

A              1
B               3

C              6
D              3

my requirement I want to hightlight A & C , Bcoz its pre &  Post values are different . Please help me with dax for that

[v-luwang-msft]

Hi @RENJITH_R_S ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.

And the following article is a little similar to your case,wish it is helpful for you!

Identify matching results:https://community.powerbi.com/t5/Desktop/Identify-matching-results/td-p/1795955 

 

Best Regards

Lucien

[Jihwan_Kim · Accepted solution]

Hi, @RENJITH_R_S 

Please check the below picture and the sample pbix file's link down below.

I created a measure for highlight and inserted it as conditional formatting rules.

Highlight measure =
VAR newtable =
SUMMARIZE (
CALCULATETABLE ( 'Table', REMOVEFILTERS ( 'Table'[Pre/Post] ) ),
'Table'[Pre/Post],
"@value", SUM ( 'Table'[Value] )
)
RETURN
IF (
COUNTROWS ( newtable ) > 1
&& MINX ( newtable, [@value] ) <> MAXX ( newtable, [@value] ),
1,
0
)

https://www.dropbox.com/s/34dsv4h5wgnqwof/renjith.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[selimovd]

Hey @RENJITH_R_S ,

what do you mean with you want to highlight A & C?

Best regards

Denis

[RENJITH_R_S]

@selimovd  Back ground conditional Format

[selimovd]

Hey @RENJITH_R_S ,

sure, that's possible.

Create a measure that has a specific value for the status like this here:

HighlightMeasure = IF(MAX(Table[country]) in { "A", "C" }, 1, 0)

Then go to conditional formatting of the column "status":

And then set the background color to change when the measure is 1:

Afterwards the background Color will change.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[RENJITH_R_S]

@selimovd , Sorry  for my explaintion, as an example I told to High light background of A & C. I want to highlight the items which having values different in Pre & Post