I want help in creating a bar graph with two date columns in the same table

[suadmohammed]

My data table has two date columns as per below snip. I want a bar graph with two bars for each month , one bar for how many were received in a given  month and one bar for how many were completed in a given month. I can only make two seperate graphs for this but i cant figure out how to have both columns displayed on the same visual

[suadmohammed]

Hi jaineshp . Thanks for taking a look at my problem and your solution. I tried the DAX solution and i had a question. for the x axis which columns month should i use since i dont have a month column. 

[MasonMA]

HI @suadmohammed 

The Power Query reshape is a correct modeling solution, which makes the chart trivial and reusable for other visuals too.

In Power Query, you can follow the UI approach or paste below M code in a New Query, 

let
    Source = FactRaw, //Replace your table name
    ReceivedTable = Table.SelectColumns(Source, {"Item", "Date Received"}),
    ReceivedRenamed = Table.RenameColumns(ReceivedTable, {{"Date Received", "Date"}}),
    ReceivedWithStatus = Table.AddColumn(ReceivedRenamed, "Status", each "Received"),
    CompletedTable = Table.SelectColumns(Source, {"Item", "Date Completed"}),
    CompletedRenamed = Table.RenameColumns(CompletedTable, {{"Date Completed", "Date"}}),
    CompletedWithStatus = Table.AddColumn(CompletedRenamed, "Status", each "Completed"),
    CombinedTable = Table.Combine({ReceivedWithStatus, CompletedWithStatus}),
    SortedTable = Table.Sort(CombinedTable, {{"Date", Order.Ascending}})
in
    SortedTable

Disable loading your Old table ('FactRaw' in below Demo) and only load your new table ('Fact')

Build a Date table with DAX (Adjust you date range accordingly)

DateTable =
ADDCOLUMNS (
    CALENDAR ( DATE(2025,4,1), DATE(2025,10,31) ),
    "Year", YEAR ( [Date] ),
    "Month", MONTH ( [Date] ),
    "Month Year", FORMAT ( [Date], "MMM YYYY" )
)

 Create a one-to-many relationship 

Tweak the formatting so that you will have the right visual. 

In case you would like to see the demo click here. 

[Natalie_iTalent]

Hello @suadmohammed,

The comment that you responded to has been removed.  I hope you are able to get a solution for your question.

Best,

Natalie H.

Community Manager