Forum Discussion
Displaying a date vs a target date
- 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.
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.