Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi team,
I'm trying to create a visual that shows the top 5 variables in a specific column that experienced the largest change since the previous month. So as we add data on a monthly basis, I would like to show the largest 'movers' each time we refresh the data (on a monthly basis). The variables are string values.
My inputs are the following measures I've created:
@Anonymous , Not very clear. But TOPN and Rank can help you
example top 5 client by difference
Top 5 Rank = CALCULATE([Difference ],TOPN(5,all('CLIENT DATASET'[CLIENT]),[Difference],DESC),VALUES('CLIENT DATASET'[CLIENT]))
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415
HI there,
Thank you for offering a solution.
I am trying to get the Top N relative changes , not absolute changes. So both your solution and my current one is showing absolute changes. E.g. X1 = 1000 , X2 = 3000 ; A1 = 200 A2 = 1000 . The larger relative change from month 1 to 2 happened to variable A not Variable X, but the current solution would show X above A in a table for instance.
Just to add I have created a new measure which calculates the total for each column but only for the latest month:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |