How to display current month in line chart?

[Niels_T]

Hello,

I would like to display the sales of the current month in a line chart and that it automatically updates itself.

I've written a DAX measure but it doesn't seem to work: 

Current Month Sales = TOTALMTD(SUM('Magento - Order Line'[Row Total Incl. Tax]),DATESMTD('Calendar'[Date]))

Currently I get this:

However I would like to get something like this:

[PhilipTreacy · Accepted solution]

Hi @Niels_T 

You're using a date hierarchy in your visual

Change that to just use Date.  Click the down arrow beside Date (in the axis), then click on Date.

Regards

Phil

[PhilipTreacy]

Hi @Niels_T 

Download sample PBIX file

Try this, note the 3rd parameter which is a filter

Current Month Sales = TOTALMTD(SUM('Table'[Value]),'Calendar'[Date], MONTH('Calendar'[Date]) = MONTH(TODAY()))

regards

Phil

[Niels_T]

When I use this measure my graph becomes blank:

I looked into the power BI file that you provided, and I don't know what you are doing different. 

I have a date table and all that so that shouldn't be an issue as well.

[PhilipTreacy · Accepted solution]

Hi @Niels_T 

You're using a date hierarchy in your visual

Change that to just use Date.  Click the down arrow beside Date (in the axis), then click on Date.

Regards

Phil

[Niels_T · Accepted solution]

Hey Philip,

I tried what you did but this is the result I get:

I have set a filter now on date -> relative date -> show items when the value: is in this year and this fixed the issue

The measure I used for current month: 

Current Month Sales = TOTALMTD(SUM('Magento - Order Line'[Sales]),'Calendar'[Date], MONTH('Calendar'[Date]) = MONTH(TODAY()))

Thanks Philip for the help!

[amitchandak]

@Niels_T , what you have taken on x-axis?

What you are displaying on the x-axis on the visual below?

[Niels_T]

The two visuals are not related to each other. The visual below also comes from Google Data Studio.

The axises contain the following data: