cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BlueTiger
Helper I
Helper I

Filter not working unless included in Value field

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

 

Forum_HelpWithRankFilter.PNG

 

1 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!

View solution in original post

2 REPLIES 2
v-easonf-msft
Community Support
Community Support

Hi, @BlueTiger 

Sorry, can you share more details?

I did not find any difference between these two tables.

What is your expected result?

66.png

 

Best Regards,
Community Support Team _ Eason

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!

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors