Forum Discussion
Show same Top N categories for different visualisations
Hi, I have a visualisation below which shows the top 3 answers for the category which is selected in a slicer. The "% A4" is a measure calculated like this: % A4 = CALCULATE(DISTINCTCOUNT(A4[U...
meg222 , I doubt the second visual. But you can have two top3 measure using topn and use those in visual
example
TOP3 Category net = CALCULATE([Net], TOPN(3,ALLSELECTED('Item'[Category]), [Net],DESC), values('Item'[Category]))
TOP3 Category gross= CALCULATE([gross], TOPN(3,ALLSELECTED('Item'[Category]), [gross],DESC), values('Item'[Category]))
TOPN: https://youtu.be/QIVEFp-QiOk
Power BI- TOPN with Others- https://youtu.be/I_TY4hVlzAE
Thanks for your reply.
The first visual is working fine and showing what I need. It is the second visual I am having problems with - do you think it is possible to make it so that the second visual shows the same top 3 answers as the first visual?