Forum Discussion

ismails's avatar
ismails
Frequent Visitor
8 years ago
Solved

Top N within Line & Clustered Column Chart

Hey Power BI Community, I have a question regarding potential argumentation and context-changing of Power BI Top N filter capabilities. When i tested within single value/single bar chart, it worked...
Need Help
Show and Tell
Tips and Tricks
  • ismails's avatar
    ismails
    8 years ago

    Hi Thejeswar

     

    Thank you for your advice, finally i found  my problem solving.. i used one column to sorting measures.

     

    IncentiveCashBot3 = 
    CALCULATE (
     [IncentiveCashfinal],
     
     TOPN ( 3, CALCULATETABLE(VALUES(IncentiveSalesForce[MainDealerName] ), ALL(IncentiveSalesForce[MainDealerName])), [IncentiveCashfinal],ASC),
    values( IncentiveSalesForce[MainDealerName]) 
    )

    IncentiveCreditBot3 = 
    CALCULATE (
     [IncentiveCreditfinal],
     
     TOPN ( 3, CALCULATETABLE(VALUES(IncentiveSalesForce[MainDealerName] ), ALL(IncentiveSalesForce[MainDealerName])), [IncentiveCashfinal],ASC),
    values( IncentiveSalesForce[MainDealerName]) 
    )

      Thank you

Stachu's avatar
Stachu
Community Champion
8 years ago

I think the issue may be realated to using both  DealerName and MainDealerName in axis - which one of them you filter by Top3?
I think if you then drill down/up it keeps the filter from original setup, which may result in some weird results

ismails's avatar
ismails
Frequent Visitor
8 years ago

Hi Stachu ,

 

I tried take out the dealer name, then i choose Bottom 3 , the result like below. I think the issue related to using cash,credit and incentive. 

 

 

 

  • Thejeswar's avatar
    Thejeswar
    Super User
    8 years ago

    Hi ismails,

    I think the Top3 related issue in this visual is because, 

    In case of Cash and Credit, your Bottom 3 MDs are

    1. PT INDAXO TRADING

    2. HSO and 

    3. Berkah Motor

     

    Whereas when it comes to Incentive, your Bottom 3 Varies

    While PT INDAXO TRADING is still one of then Bottom 3 in incentives, the others in Bottom 3 is different. In this case

    1. Daya Motor and

    2. Terang Abadi 

    instead of 

    2. HSO and 

    3. Berkah Motor as in the case of Cash and Credit

     

    Since Line Value is a separate value, the Power BI is finding Bootom 3 for Column Values and Line Values separately.

     

    The Same happens for your Top 3 also. (Shown in your image in the question)

     

    Hope this helps!!!

    • ismails's avatar
      ismails
      Frequent Visitor
      8 years ago

      Hi Thejeswar

       

      Thank you for your advice, finally i found  my problem solving.. i used one column to sorting measures.

       

      IncentiveCashBot3 = 
      CALCULATE (
       [IncentiveCashfinal],
       
       TOPN ( 3, CALCULATETABLE(VALUES(IncentiveSalesForce[MainDealerName] ), ALL(IncentiveSalesForce[MainDealerName])), [IncentiveCashfinal],ASC),
      values( IncentiveSalesForce[MainDealerName]) 
      )

      IncentiveCreditBot3 = 
      CALCULATE (
       [IncentiveCreditfinal],
       
       TOPN ( 3, CALCULATETABLE(VALUES(IncentiveSalesForce[MainDealerName] ), ALL(IncentiveSalesForce[MainDealerName])), [IncentiveCashfinal],ASC),
      values( IncentiveSalesForce[MainDealerName]) 
      )

        Thank you