Displaying a date vs a target date

[jcarville]

Hi guys,

As the title says I'm looking a nice way to display a date vs a target date.

There are thresholds involved so if a date goes beyond a target it would be nice for it to change colour.

Any help would be appreciated.

Thanks.

[Vaj99]

Hi , I'm trying to visualise something simialar, I'm fairly new to powerbi, do you have a solution

[Greg_Deckler]

Given a table of dates and other information, you could create a custom colum that is basically your target date, another custom columns would be:

IF([date] > [target]),1,0)

now you would have a flag field that you could relate to something like an images table with image urls for 1 and 0. Conditional formatting is not yet a feature.

[jcarville]

I understand your formula completely, I presumed I would need something like this.

I'm interested in finding out more about using image urls, I didnt think using them with a table was possible in Power BI.

Appreciate all suggestions as this problem has me stuck for a while.

[Greg_Deckler · Accepted solution]

Almost positive they work in a table, I'm pretty sure an early version of my OSU file used a table. Essentially, you plug in the URL to a column, Enter Data is useful for things like this. you also have your key column. After loading, you go to the Modeling area, modeling tab, pick your image url column and set the Data Categorization to Image Url, then when it gets displayed, it displays the image not the text of the URL.

[jcarville]

Brilliant thanks for that, never knew that was possible, it gives me another option to create a mock up of before making my final decision.

Its a pity it has to be a Image URL and not an image from a local source.

I'm still open to other solutions/suggestions.

Cheers guys.

[greggyb]

We'll need some more details about your data model's structure, and what measures (if any) are involved here. Your description is far too vague to be able to offer useful responses. If you can share sample data (preferably in a .pbix hosted on OneDrive or similar, definitely not as a screenshot of data in your model (no one wants to copy all your data over by hand)) that's the most helpful in being able to offer constructive feedback.

[jcarville]

Thanks for the reply, it's much appreciated.

I have uploaded a .pbix to OneDrive here: https://onedrive.live.com/redir?resid=3A26887851AC0434!447&authkey=!AAypu20D4TzMNzM&ithint=file%2cpb...

I haven't seen the companies data but it will be relatively straight forward like this example. So each KPI has an Initial Target Date set when they are created but over time they might be completed later/sooner, hence New Target Date.

If a KPI is on course to be completed by it's Initial Target Date ideally it should be green, otherwise it should be red.

These don't have to be displayed on the same visual. I just need to show KPI name, and some nice way of showing how New Target Date compares to Initial Target Date.

Thanks.