topic Re: Line graph show first date of the month till last date of the month by filter in Desktop

Line graph show first date of the month till last date of the month by filter

deckamaha — Tue, 31 Oct 2017 12:35:37 GMT

I have a question.

Suppose that i have a single date filter/slicer, and i have a line graph like above.

So if i choose 1-October-2017 on the filter, then the line graph will show data from Date 1-Oct-2017 till 31-Oct-2017.

Or if i choose 1-December-2016 on the filter, then the line graph will show data from Date 1-Dec-2016 till 31-Dec-2016.

How can i do that in power BI? should i manage the table relationship? or is there any other trick to do that?

Thanks in advance.

Re: Line graph show first date of the month till last date of the month by filter

v-huizhn-msft — Wed, 01 Nov 2017 06:11:36 GMT

Hi deckamaha,

I try to reproduce your scenario using the sample table below.

First, you need to create a new date table only have the date column using the formula by click "New Table" under Modeling on home page.

Date = SELECTCOLUMNS(Table1,"Date",Table1[Date])

Then create a measure using the formula.

Measure =
CALCULATE (
    MAX ( Table1[sale] ),
    FILTER ( Table1, Table1[Month] = MONTH ( SELECTEDVALUE ( 'Date'[Date] ) ) )
)

Finally, create a slicer including 'Date'[Date], a line chart including [Date] and measure. When you select 1-October-2017 on the slicer, the line graph will show data from Date 1-Oct-2017 till 31-Oct-2017 as follows.

Please respond to me if you have any other problems.

Best Regards,
Angelia

Re: Line graph show first date of the month till last date of the month by filter

Anonymous — Wed, 09 Mar 2022 16:34:16 GMT

Hello, I did the same steps, I created two tables : table 1 (with the columns: date, sales, month and year) and table date.
I used the measure that you put, but it shows me a a single date filter/slicer' a single value in the graph' like above !! Thanks for your help