DAX Highlight Range Selection

JK14 — Tue, 19 Mar 2024 09:44:35 GMT

Hi All

I would love to have some helping hands with a PowerBI DAX formula to multi-select highlight range results from filter. At current I can get DAX to highlight 1 set of selection from filter, however if I select more than 1 it will highlight all values between Max and Min and not as ones specifically selected.
For example, if selection range was both 0-49 and 150-199 at the moment report will highlight all results from 0-199.

I have a table with range

Order	MinValue	MaxValue	Range
1	0	49	0-49
2	50	99	50-99
3	100	149	100-149
4	150	199	150-199
5	200	249	200-249
6	250	299	250-299

Background colour condition based off below condition being 1:

Result =
VAR ComMin = [CommittedMin]
VAR ComMax = [CommittedMax]
VAR ComValue = [Committed]
RETURN
IF(ISFILTERED('Table'[Range]), IF(NOT(ISBLANK(ComValue))&&ComValue >= ComMin && ComValue <= ComMax, 1, 0), 0)

And a few more measures:

CommittedMin = DIVIDE(MINX(VALUES(' Difference'[MinValue]), [MinValue]), 100)
CommittedMax = DIVIDE(MAXX(VALUES(Difference'[MaxValue]), [MaxValue]), 100)
Committed = IF([Check] <> 0, BLANK(), DIVIDE([Billed], [Planned], 0))

Anyone who can shed some light will be greatly appreciated, thank you.

Re: DAX Highlight Range Selection

Jihwan_Kim — Tue, 19 Mar 2024 16:24:01 GMT

Hi,
Please check the below picture and the attached pbix file.

background color condition: = VAR _t = FILTER ( ADDCOLUMNS ( 'Range', "@condition", IF ( [Percentage:] >= 'Range'[MinValue] && [Percentage:] <= 'Range'[MaxValue], 1 ) ), [@condition] = 1 ) RETURN IF ( ISFILTERED ( 'Range'[Range] ), IF ( COUNTROWS ( _t ) > 0, 1, 0 ) )

Re: DAX Highlight Range Selection

JK14 — Wed, 20 Mar 2024 04:22:32 GMT

Thanks you very much Jihwan_Kim! This works perfectly and I never would have thought of ADDCOLUMNS()!

Much appreciated your help 😀

topic Re: DAX Highlight Range Selection in DAX Commands and Tips

DAX Highlight Range Selection

Re: DAX Highlight Range Selection

Re: DAX Highlight Range Selection