Show next event date with images

[fajemile]

Hi there 

So I have this issue where I am trying to show the next event. In this case it is the next game. I can do relative flitering by date but that only allows me to show the next x games. Advanced flitering only shows the date after a fixed day rather than the current day the report is being looked at. 

 

In the photo Arsenal V Cardiff city is the next game. I manged to fliter the table to show the next 7 days. I did 7 days just to make sure there was a game within the time frame. Ideally  would want next game irrespective of how many days untill the game. The second thing is having the corresponding logo with the team. I have changed the interactions but it still does not work. Should be arsenal and cardiff.

Thanks for the help

[v-cherch-msft]

Hi @fajemile

Could you share the .pbix file which could reproduce your scenario?Please explain more about your expected output.Sample data and expected output will be helpful to provide an accurate solution.You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Regards,

Cherie

[fajemile]

Hi @v-cherch-msft

Thank you for the reply, my organisation has blocked me sharing files with the public on onedrive; is there another way I could send it?

Files

[v-cherch-msft]

Hi @fajemile

Could you paste some simplified sample data and explain about your expected output here?Please refer to How to Get Your Question Answered Quickly.

Regards,

Cherie

[fajemile]

Hi @v-cherch-msft

Apologies for the way I had my last post worded. 

Hopefully this will make a bit more sense. 

Below is my fixtures dataset for a two week period

Date	Home	v	Away
03/02/2019	Team B	v	Team A
09/02/2019	Team C	v	Team A
14/02/2019	Team D	v	Team A
21/02/2019	Team A	v	Team D

The other dataset I have is for the images as seen below

This is what has been imported into power bi; the team name and image url. I have just overlayed the photo of the team name over the url so you have an idea of what the team images look like. 

I have made a relationship between the home and away columns in the fixtures table and team in the images table. They have a many to one relationship in both directions as seen below. 

At the moment this is what I am getting. There is a table with all the games that will be occuring sorted by date. But i only want a table that will show the next game only in acordance with the current date. I can do relative flitering by date but that only allows me to show the next x amount of games. Advanced flitering only shows the date after a fixed day rather than the current day the report is being looked at. The next game is on the 3rd feb and it is team b vs team a. I made two other tables below the images one has the date and the home and the other one has the date and away.

I have flitered this value so you could see the games within the next 7 days which is why it is only the 3rd of feb as opposed to the full table. Next I have the pictures; at the moment it is only show team d and team d but its supposed to show team b v team a. 

This is the type of interactions I have for the photos

This is ultimatly what I a trying to achieve 

[v-cherch-msft · Accepted solution]

Hi @fajemile

Please check the attached file.Replace the url as 1,2,3,4 and add some visual level filters to achieve that.

Regards,

Cherie

[fajemile]

Thank you @v-cherch-msft this worked perfectly!