Forum Discussion
Dynamic Top N filter for graph
Hi, Thank to Gilbet's post 'Dynamic TopN made easy with What If Parameter' I have created a top N filter in my PowerBI report. It is working well for table visual. But I have a line graph which...
Hi,
Thank you for the reply.
I have added an graphical representation of desired and actual output, please find this link.
Thanks.
Hi Cherry,
I was just verifying the file that I have sent you, magically, the TopN filter from DAX is working after adding the required measure in the inbuilt TopN filter, i.e., topN in the 'desired' sheet if I give an arbitrarily large input of for the inbuilt TopN under filters, the dynamic one is giving desired output.
I do not understand the logic behind it, though.