Forum Discussion
Dynamic Top N
Hi itsmeanuj
Kindly check below results:
1. You should unpviot the columns firstly:
2. Then create the hierarchy by dragging the values to attibute, and generate the visual:
Pbix attached.
You have create different rank or Top N measure and then use filter like
and use top N to get top measure
https://docs.microsoft.com/en-us/dax/topn-function-dax
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin
amitchandak - in the link you shared, there is only one column of date where are you calculating and filtering on different time periods. However, in my example, there are 2 different columns and based on the slicer filter it should show the "TOP N". e.g. if a user selects Area in slicer, result would be Top 5 areas on the basis of Sales.
Area Territory Area Sales Calls Area5 19875 197 Area6 19423 192 Area3 16481 163 Area2 14193 139 Area4 11316 111 Hi itsmeanuj
Kindly check below results:
1. You should unpviot the columns firstly:
2. Then create the hierarchy by dragging the values to attibute, and generate the visual:
Pbix attached.
