Dynamic

Question

Hello,&nbsp;Can anyone guide me how to make top 10 business process type dynamic?please refer to the below image -&nbsp;In the above image top 10 business process type is showing..I want to give an option where user can select business process type as per their choice. It may be top 5, 6,9 etc..&nbsp;Thanks for help!&nbsp;

amitchandak · Answer

Anonymous , Not very clear.
&nbsp;
You can Create TOP N with what if
Refer https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415

anonymous · Answer

amitchandak&nbsp;I have edited the post.

amitchandak · Answer

Anonymous , Blog I posted may be relevant , check that

anonymous · Answer

Hi Anonymous,
Can you please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly&nbsp;&nbsp;
Regards,
Xiaoxin Sheng

anonymous · Answer

amitchandak&nbsp;, I tried by following the link you have shared but it's not working.&nbsp;measure that I am using-&nbsp;TopN = VAR SelectedTop = SELECTEDVALUE('Parameter'[Parameter])RETURNSWITCH(TRUE(),SelectedTop = 0, COUNT('table'[field]),RANKX ( ALLSELECTED( 'table'), COUNT('table'[field]))&lt;= SelectedTop,COUNT('table'[field]))

Forum Discussion

Dynamic

8 Replies

Related content

Dynamic Filter

Dynamic RLS

RLS Dynamic

Dynamic Subscription

dynamic insights