Forum Discussion
Helper IDynamic Top N chart with conditional formatting in a Top N table
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.
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.
2 Replies
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_22tanks