color change based on applied filter

[szymonswiezyfg]

Hi, I would like to change the color formatting in columns based on the selected range on the filter. For example, if I select the range from 2005 to 2010, I want the color to change to blue, while the rest remains gray. I've written various formulas, but I keep getting an error: "DAX comparison operations do not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values."

DAX:
color = SWITCH( TRUE(), AND( VALUE('Calendar'[Date]) >= MIN('Calendar'[Date]), VALUE('Calendar'[Date]) <= MAX('Calendar'[Date]) ), "blue", "gray" )

[szymonswiezyfg]

Thank you very much, it works. Is it possible for such a functioning slicer to also affect filtering in other visualizations in the report? If so, how? In this case, I would like this type of slicer to filter colors on the map.

[amitchandak · Accepted solution]

@szymonswiezyfg , Make sure in such case slicer is coming from disconnected Date Table

//Date1 is independent Date table, Calendar is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = minx(allselected(Date1),Date1[Date])
return
if( max('Calendar'[Date]) >=_min && max('Calendar'[Date]) <=_max, "blue", "gray" )

On my Data

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf
Power BI Field Parameters, Keep Axis Sort intact| Always Sort on X/Categorial Axis: https://youtu.be/GfBrB6czByw