Show top 3 based on months using card visuals

bluerobot 

Create a measure:

Rank Destinations = 
IF (
ISBLANK(CALCULATE(SUM('Table'[Value]))), // Check if Value is blank for the current context
BLANK(),
RANKX(
FILTER(
ALL('Table'), // Replace 'Table' with the actual name of your table
'Table'[Month] = SELECTEDVALUE('Table'[Month]) // Filter by current month
),
CALCULATE(SUM('Table'[Value])), // Rank by Value directly
,
DESC,
DENSE
))

Add visual level, bottom 3 filter:

Let me know if this resolves the issue or if you need further assistance!

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn