conditional value in slicer

[sdobi05]

Hi All, Below is my query :

i have two date column named as 'current date' and 'previous date' at ID column level. In a custom column i am comparing both the dates and if it does not match then i am changing the background color of both the dates value field.

Now, i want to give slicer where selected ID value should give only background color is applied.

This is how i am comparing both the dates :

Chkdate = 

var prevdate=calculate(min(prevDate))

var curdate = calculate(min(curDate))

return

if(prevdate<>curdate,"#ff7f7f"."#ffffff")

i am passing above Chkdate column in conditional formatting of my date columns.

[v-yiruan-msft]

Hi @sdobi05 ,

I just created a sample pbix file for you, please check if that is what you want.

Best Regards

Rena

[amitchandak]

@sdobi05 , based on what I got

with a date table, few options

Last Day = CALCULATE(Min(Table[Value]),dateadd('Date'[Date],-1,Day))

This Day = CALCULATE(Min(Table[Value]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])))
Last Day = CALCULATE(Min(Table[Value]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])-1))
Last Day = CALCULATE(Min(Table[Value]), previousday('Date'[Date]))

Color Measure

color = if([This Day] <> [Last Day] ,"#ff7f7f","#ffffff")

or

color = if([This Day] <> [Last Day] ,selectedvalue(Color[Color]), "#ffffff")  /// need to Slicer of hex color using an independent table 

Use in conditional formatting using "Field Value" Option

[Anonymous]

filterSlicer = 

var prevdate=calculate(min(prevDate))

var curdate = calculate(min(curDate))

return

if(prevdate<>curdate,1,0)

Use above dax measure as filter slicer pulling it to the filter pane and select the value should be eaqual or greater then 0 in th filter.(slicer) User will only see those values only where there is change in the background using same logic.