Forum Discussion

Frequent Visitor

8 years ago

Solved

Trend line chart

HI I have a dataset with several rows showing 1 order per row I need to show a chart showing Total orders per week, something like this I have a measure that counts the orders on a se...

Tutorial Requests

Eric_Zhang
8 years ago
mejiaks

Try to create a calendar table

Then link your table with this calendar table.

Then remove one filter in your measure.

Orders Week = CALCULATE ( DISTINCTCOUNT ( TruckingData[OrderNO] ), FILTER ( TruckingData, TruckingData[RevType] <> "EREPO" ) ) + 0

In the line chart, put the 'Dimdate'[weeoNo] as axis and the measure as value.

Eric_Zhang

Microsoft Employee

8 years ago

mejiaks

Try to create a calendar table

Then link your table with this calendar table.

Then remove one filter in your measure.

Orders Week =
CALCULATE (
    DISTINCTCOUNT ( TruckingData[OrderNO] ),
    FILTER (
        TruckingData,
        TruckingData[RevType] <> "EREPO"
            
    )
)
    + 0

In the line chart, put the 'Dimdate'[weeoNo] as axis and the measure as value.