Filter not working unless included in Value field

[BlueTiger]

I am using RANKX to create a leaderboard, 1st, 2nd, 3rd place. A picture is displayed using the "Simple Image" visual for each place on the podium.

The problem I have is that multiple images are appearing for each picture place on the podium, I should have only one result.

My filter for 1st place is Sales Month = this month and Rank = 1.

As a test I've converted the image visual into a table, and I can see it is incorrectly listing every image. I've checked everything and it seems correct, although clearly something is wrong.

The strange thing is that when I add into the table the same Rank field I am using in the filter it immediately fixes it to only return a single result, but when I remove the Rank field from the value it breaks again.

I made a sample version using the Northwind DB to demonstrate the problem, but of course it works perfectly in that version!

If anyone has experienced this before has an ideas on what the issue could be then I'd be grateful for some pointers in the right direction.

Here's the sample version I created that works in case you want to get an idea of what I'm talking about, although unfortunately it doesn't demonstrate the actual problem.

Sample PBIX Download

[v-easonf-msft]

Hi, @BlueTiger 

Sorry, can you share more details?

I did not find any difference between these two tables.

What is your expected result?

Best Regards,
Community Support Team _ Eason

[BlueTiger · Accepted solution]

Hi,

Sorry my example is not great because it works (but I don't know how to make it break!)... I cannot post the real world data unfortunately. I was expecting a single result as in the picture, but in the real data I was receiving every picture for Product.

I actually managed to workaround this issue myself this morning and it was very simple. All I had to do was add the rank field to the "Alt Text" for the image and this was enough to fix it! Happy Days!