Dynamic Top N chart with conditional formatting in a Top N table

Hi RSSILVA_22 ,

First of all, I found that I can not open your .pbix file. Can you change the way to upload the file? Such as sharepoint and so on.

I create a simple example below. Firstly I create a table.

Then I create two measures.

Measure =
VAR _Slicer =
    MINX ( ALLSELECTED ( 'Table 2' ), 'Table 2'[Number] )
RETURN
    IF (
        MAX ( 'Table'[Number] ) >= _Slicer,
        UNICHAR ( 128308 ),
        UNICHAR ( 128309 )
    )

Measure 2 =
VAR _Slicer =
    MINX ( ALLSELECTED ( 'Table 2' ), 'Table 2'[Number] )
RETURN
    SUMX ( FILTER ( 'Table', 'Table'[Number] < _Slicer ), 'Table'[Sales] )

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.