Forum Discussion

Gus_C's avatar
Gus_C
Frequent Visitor
5 years ago
Solved

Multiple Top N in the x-axis

Hi all, been struggling with creating a particular graph this morning:   I am looking to create a bar graph with 4 bars: Top 5, top 10, top 20, and top 50 clients by value of sales. Essentially wi...
Need Help
Show and Tell
Tutorial Requests
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    You can create a single disconnected table like this one called 'TopNTable'.

     

    Label

    TopNValue
    Top 5 5
    Top 10 10
    Top 25 25

     

    You can then use the Label column in your visual, and use MIN(TopNTable[TopNValue]) in a variable, and then use that variable in your TOPN measure expression

     

    Dynamic TopN Measure =
    VAR selTopN =
        MIN ( TopNTable[TopNValue] )
    RETURN
        CALCULATE (
            [your measure],
            TOPN ( selTopN, DISTINCT ( Table[Clients] ), [your measure], DESC )
        )

     

    Pat

     

DataVitalizer's avatar
DataVitalizer
Icon for Super User rankSuper User
5 years ago

Hi Gus_C 

Could you please provide us with a drawing of what you are trying to acheive ? That would help us understand the request 👍.