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

TomMartens's avatar
TomMartens
Super User
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

  • estefaniamc's avatar
    estefaniamc
    Frequent Visitor
    8 years ago

    Many thanks Tom!! It works now!!

  • 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.

  • 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