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.
Dear Guru,
I need some help from you about question below.
Objective:
I would like the Power BI report to show the top two departments having the highest case count number in each month.
Power BI report to show like the one on the right:s
table structure in excel:
I have a Dax object below but it gave me the report on the left (refer top figure) instead of the report on the right.
Thank You.
Aiyosap
Solved! Go to Solution.
@aiyosap , Create a rank
Rank = rankx(filter(allseleceted(Table[Month Year], Table[Department]), [Month year] =max([Month Year])),[Count of CASES],,desc,dense)
and use visual level filter <= 2
@aiyosap , Create a rank
Rank = rankx(filter(allseleceted(Table[Month Year], Table[Department]), [Month year] =max([Month Year])),[Count of CASES],,desc,dense)
and use visual level filter <= 2
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 |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |