Forum Discussion

estefaniamc's avatar
estefaniamc
Frequent Visitor
8 years ago
Solved

TOPN in graphs/Dynamic

Hi all,    I would like to display a bar graph only with top 5 values. I am using the advance filtering to show only the top values, but then when I filter in a different graph to show the top 5 va...
Tips and Tricks
  • TomMartens's avatar
    TomMartens
    8 years ago

    Hey,

     

    here you will find a pbix file.

     

    I changed the DAX of the measure that ranks the customer (guess this is what you call Payer) to

    GroupRank = 
RANKX(
	ALLSELECTED(Table1[Customer])
	,CALCULATE(SUM(Table1[Amount]))
)

    And I also changed the Interaction Setting of the chart showing the Top 5 Customer to filter

    Mark the Chart showing the countries: Menu Format, Toggle: Edit Interactions, Switch the Customer chart from Highligh to Filter, Toggle: Edit Interactions

     

    Hope this is what you are looking for

     

    Regards

    Tom

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hello Guys,

 

Is there a way I can only show top 10 Supplier Numbers (Y Axis) in the graph based on the % Grand Total Count of System Customer Number? Basically I just want to see top 10 bars in this graph. I am not able to use top N filter in Y axis value inside visual filters because it's changing the % values on the graph.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Create a RANK measure and then drag that measure in the visual filter with a condition of <=10.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hey Ashish_Mathur,

     

    Can you please help me with the rank formula syntax? Because the values on the charts are added based on unique supplier/parts/dealer number and day groups. 

     

    formula is like= for each supplier number, count (>14)/ Grand total (>14) + count (8-14)/ Grand total (8-14)  + count (2-7)/ Grand total (2-7) + count (0-1)/ Grand total (0-1)  

     

    Thanks

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      Hi,

       

      Share the link from where i can download your file.  In a simple Table, also show the expected result.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hey Ashish,

         

        Sorry for the delay. I am attaching the link herehttps://drive.google.com/open?id=0B3RVPzvmX8RMa3FiTXVodXhyMDVyMVExNGczZG83MFpfcmUw. What I need is, instead of the stacked bar charts showing all the parts/supplier/dealer numbers, I just want top 10 of them to show based on the Percentage Grand total Count of Customer Order ID. This same parameter: %GT Count of System_CustomerReferenceOrderID is used as a value in all the stacked charts.