topic Re: How to show trend of only the latest 3 Months (from Month selected) in the Line Graph? in DAX Commands and Tips

How to show trend of only the latest 3 Months (from Month selected) in the Line Graph?

Anonymous — Thu, 13 Jul 2023 12:54:08 GMT

Hi, all. I have a Line Chart that shows Revenue over Month-Year.

The Month-Year comes from the Date Table. I also have two slicers, one for the Year and one for the Month, as shown in the image

My requirement is to show the Last 3 Months from the selected Date in my Line Chart.

For example, now that I have selected May 2020, then the Line Chart should show "March 2020, April 2020, May 2020", like this,

Similarly, If I have selected January 2020, it should show "Jan 2020, Dec 2019, Nov 2019"

Or If I selected All, then it should show the Last three months from the Maximum Date in current context.

How can I achieve this in Power BI? and is it possible to achieve this without creating another Date Table?

Can anyone help out in this? Thanks.

If anyone would like to download the Sample Power BI File, you can do so from here: https://drive.google.com/file/d/1RpKYMO7xaYuioMJPQ0Hh2XkIYsfaSwWp/view?usp=sharing

Re: How to show trend of only the latest 3 Months (from Month selected) in the Line Graph?

some_bih — Thu, 13 Jul 2023 13:57:42 GMT

Hi Anonymous check https://learn.microsoft.com/en-us/power-bi/create-reports/slicer-filter-relative-time

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Re: How to show trend of only the latest 3 Months (from Month selected) in the Line Graph?

Anonymous — Thu, 13 Jul 2023 14:26:06 GMT

Hi some_bih thankyou for your reply mate i got some useful info from here but unfortunately it's not solving my problem

Re: How to show trend of only the latest 3 Months (from Month selected) in the Line Graph?

Anonymous — Tue, 18 Jul 2023 02:44:51 GMT

Hi Anonymous ,

Here are the steps you can follow：

1. Create calculated table.

Table = SUMMARIZE( 'date','date'[year],'date'[month_name])

2. Create measure.

Measure = var _year=SELECTEDVALUE('Table'[year]) var _month=SELECTEDVALUE('Table'[month_name]) var _date= MINX( FILTER(ALL('date'), 'date'[year]=_year&&'date'[month_name]=_month),'date'[date]) var _date1= EOMONTH(_date,-3) var _date2= EOMONTH(_date,0) return IF( MAX('date'[date])>_date1&&MAX('date'[date])<=_date2,1,0)

3. Place [Flag]in Filters, set is=1, apply filter.

4. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly