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

[RSSILVA_22]

Hello.

I have a test file in pbix and I'm trying to do the same with it as I see in this model:

https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/2021-W37/td-p/3760779

Can anyone do the same and repost the file so that I can analyze and learn how it was done?

Thank you.

Community_challenge.pbix 

[Anonymous · Accepted solution]

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.

[RSSILVA_22]

tanks