TOPN + an others Value in the same Line Chart

[Slycls]

hello,

I have a problem, I want to display on a line chart a TOPN (5 lines) from a table + a value (1 line) from the same table but filter on a particular column, I don't know how take it to display the 6 lines.
Thanks for your help

[tamerj1]

Hi @Slycls 

can you provide sample input data of let's say 10 rows. Also what do you want to see if the the Top 1 row is also part of the Top 5 rows?

[Slycls]

Here is an example, I would like to display in a line graph the TOP 5 brands + the brand "Laboratoire CCD" according to the segment chosen by the user. Indeed if "CCD Laboratory" is already in the TOP 5 do not display it. Thanks for your help.

[Icey · Accepted solution]

Hi @Slycls ,

Try to create two measures like so:

Rank =
RANKX (
    ALLSELECTED ( 'Table' ),
    CALCULATE ( SUM ( 'Table'[turnover] ) ),
    ,
    DESC,
    DENSE
)

Rank Filter =
IF ( [Rank] <= 5 || MAX ( 'Table'[BRAND] ) = "Laboratoire CCD", 1 )

Best Regards,

Icey

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

[Slycls]

Hi @Icey ,

Perfect, thank you very much

[amitchandak]

@Slycls , refer if these can help

TOp N with Others
https://www.youtube.com/watch?v=UAnylK9bm1I
https://blog.gbrueckl.at/2019/05/power-bi-dynamic-topn-others-with-drill-down/

[Slycls]

Thank you for your feedback, but this is not exactly my need.

I have a fact table and a product table (with name, brand, category, laboratory...), I would like to display in a graph the TOP 5 of all the brands and in addition the TOP 1 of the brand filter on the laboratory field. Depending on the user's choice, I always want to see the brand of a particular laboratory appear.