Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
I have a Line & Clustered Column Chart right now:
When i selected Top 3, the result is not applicable. Is there any depedency data visualization because i used 3 data sources??
My concern is when i select Top 3 the result is top 3.
Please advice
Thanks
Solved! Go to Solution.
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
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
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.
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!!!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |