Excel scenario for bar chart

Occasional Visitor

Hello All,


Here is my scenario- Please help to get it resolved


I have a Bar chart created on top of Project id, Project Status , Project Status Created date and Project Name. This is working fine as expected as there is no big challenge in this scenario so far. however , when some one updated Project Status  for the Same project multiple times, we are in a confused state to depict the same in a Bar chart. if the first submission of Project A is in On Track and second submission for the same project is Off Track- if the bar chart is filtered with Project status- project will be listed on both categories ie in On track and offtrack- We need it based on Project Status Created date column as only Project Status updated in latest created date should be visible in Bar Chart. can some one please suggest a solution- this will be applicable for Power Bi chart as well

0 Replies