Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

New item indication

I have a strange question.

Is there a way to indicate a new item that appear on a list in either the Table or the "Table" Visualization?

Why? you may ask. We have a list of projects that would change phases, and I would like to know when a project goes from the one phase into another. The list is getting so big that it is quite difficult to keep tabs on it and thought if I can have some sort of indication which are the new ones that came on for TODAY it would be great. 

 

The issue is that there are no date against these changes or when they are logged.

Thanks in advance.

Kind Regards
Jeremy

Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous ,

     

    Can you please share more details? How do you identify it as a new item, if there is no date logged? What effect do you want, put them into a new table or highlight the changed items? You could post some sample data and  the expected output. And you could mask the sensitive data when you post the sample. Then we can help you as soon as possible.

     

    Please see this post regarding How to Get Your Question Answered Quickly:

     https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

     

    Best Regards,

    Xue Ding 

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks for your reply Xue Ding,

       

      The Data is basically 3 columns, "ID, Project Name and Phase". The total number of projects are then about 250, I then filter just on the "Initiation" phase to return about 40 projects. Project managers would then change the other projects from a certain phase into "Initiation" which would change the 40 to 41, etc. I would then like to know which one of those projects are the ones that are "new" on the list, basically highlighting them or even in a new column have the word "new" come up until the next one or 2 comes up.

       

      Unfortunately we do not capture an identifier like a date or status when we change over the phases.

       

      I hope this make sense, I am sorry, I am extremely new to Power BI and Data for that matter.

       

      Thanks

      Kind Regards

      Jeremy