Forum Discussion

JK14's avatar
JK14
New Member
2 years ago
Solved

DAX Highlight Range Selection

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, h...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    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 ) )

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
2 years ago

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 ) )