Hi there,
Is there a way to show the Top N of all the charts and filters on a page? I welcome any M Language options/combinations as well.
Thank you!
TopN.zip (66.9 KB)
bumping this post
Hello @powerbideveloper
Thank you posting your query in the forum.
I have created the Rank Price measure now based on your selection all the visual will gets filtered, you can replace the [Total Price] measure with [Total Budget] and [Total Cost] in the Price_TopN to get the same.
I’m also attaching the solution PBIX file for your reference.
TopN_Dharma.pbix (53.5 KB)
Measure -
Price_TopN =
VAR _Seletedvalue = SELECTEDVALUE(‘Top N’[Top N])
VAR _Rankx_Product = RANKX(ALL(‘Product’[Product]), [Total Price], , DESC)
VAR _Rankx_Country = RANKX(ALL(County[County]), [Total Price], , DESC)
VAR _Rankx_SalesPerson = RANKX(ALL(‘Sales Person’[Sales Person]), [Total Price], , DESC)
VAR _Rankx_Customer = RANKX(ALL(Customer[Customer]), [Total Price], , DESC)
VAR _Condition =
SWITCH(TRUE(),
ISINSCOPE('Product'[Product]),
IF(_Rankx_Product<=_Seletedvalue,[Total Price],BLANK()),
ISINSCOPE(County[County]),
IF(_Rankx_Country<=_Seletedvalue,[Total Price],BLANK()),
ISINSCOPE('Sales Person'[Sales Person]),
IF(_Rankx_SalesPerson<=_Seletedvalue,[Total Price],BLANK()),
ISINSCOPE(Customer[Customer]),
IF(_Rankx_Customer<=_Seletedvalue,[Total Price],BLANK()))
Return
_Condition
2 Likes
Hi @powerbideveloper, did the response provided by @Dharma help in solving your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.