cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ismails Frequent Visitor
Frequent Visitor

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 for me.

 

chart01.PNG

 

 

I have a Line & Clustered Column Chart right now:

 chart1.PNG

 

 When i selected Top 3, the result is not applicable. Is there any depedency data visualization because i used 3 data sources??

 chart2.PNG

 

 

 My concern is when i select Top 3 the result is top 3.

 

 

 

 Please advice

Thanks

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
ismails Frequent Visitor
Frequent Visitor

Re: Top N within Line & Clustered Column Chart

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

4 REPLIES 4
Super User
Super User

Re: Top N within Line & Clustered Column Chart

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 Frequent Visitor
Frequent Visitor

Re: Top N within Line & Clustered Column Chart

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. 

 

 

chart4.PNG

 

Thejeswar Senior Member
Senior Member

Re: Top N within Line & Clustered Column Chart

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 Frequent Visitor
Frequent Visitor

Re: Top N within Line & Clustered Column Chart

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