Forum Discussion

ishanajmani's avatar
ishanajmani
Regular Visitor
9 years ago

Creating a graph based on dates

I’m new to Power BI and trying to gain exposure, so I’d really appreciate if someone can guide me in the right direction.   I have the following columns that are relevant to the graph: -Report Typ...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi ishanajmani,

I need to create a graph based on the following conditions

 

If Completion Date is before TODAY, then ‘Overdue’

If Completion Date is Today or within the next 30 Days, then ‘Due in Next Month’

If Completion Date = ‘TBD’, then ‘TBD’

If Completion Date = ‘On-Going’, then ‘In-progress’

If Report Type = ‘Next 60 Days Tasks, then ‘Future Tasks’

 

I’d like to create a bar graph for the above.

What data do you want to show in the bar graph? Could you be more precisely with it(like what data for Axis field and Value field)?

 

What's the data type of the "Completion Date" column in your table? Could you post some sample data of your table with your expected result?:smileyhappy:

 

Regards