Forum Discussion
Displaying a date vs a target date
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.
- 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.
7 Replies
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.
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%2cpbix
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.
- 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.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.
- 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.
Hi , I'm trying to visualise something simialar, I'm fairly new to powerbi, do you have a solution
