cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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 Type (contains categories for tasks)

-Completion Date (due date)

-Description (Task description)

 

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.

 

I tried creating a new column called Status and tried putting filters for dates but filters only took hard dates as opposed to ‘Today’ or ‘getdate’ and static dates don’t really help.

 

I'd appreciate any feedback if I should create a filter in the graph, another column, not sure where to start...

 

Thank you!

1 REPLY 1
Highlighted
Microsoft
Microsoft

Re: Creating a graph based on dates

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?Smiley Happy

 

Regards

Helpful resources

Announcements
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors