cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Anonymous
Not applicable

I'm sure it's obvious but I'm a newbie here...

Why, when my chart is displaying the last 3 months it does so nicely but when I use the slicer to change it to show 4 months or longer it gives me this mess?

1 ACCEPTED SOLUTION
Community Support

Hi,

According to your description, i create a sample to test:

Then create a what if parameter from 0-10 first for selecting last N months.

``````Measure =
VAR a =
SELECTEDVALUE ( 'Last Month'[Last Month] ) - 1
RETURN
IF (
MONTH ( TODAY () ) - a >= 0,
CALCULATE (
SUM ( 'Table'[Days Open] ),
FILTER (
'Table',
'Table'[Date Created]
>= DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) - a, 1 ) - 1
)
),
CALCULATE (
SUM ( 'Table'[Days Open] ),
FILTER (
'Table',
'Table'[Date Created]
>= DATE ( YEAR ( TODAY () ) - 1, MONTH ( TODAY () ) - a + 12, 1 ) - 1
)
)
)``````

When select last 3 months or last 4 months, the result shows:

Here is my test pbix file:

Hope this helps.

Best Regards,

Giotto Zhi

2 REPLIES 2
Community Support

Hi,

According to your description, i create a sample to test:

Then create a what if parameter from 0-10 first for selecting last N months.

``````Measure =
VAR a =
SELECTEDVALUE ( 'Last Month'[Last Month] ) - 1
RETURN
IF (
MONTH ( TODAY () ) - a >= 0,
CALCULATE (
SUM ( 'Table'[Days Open] ),
FILTER (
'Table',
'Table'[Date Created]
>= DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) - a, 1 ) - 1
)
),
CALCULATE (
SUM ( 'Table'[Days Open] ),
FILTER (
'Table',
'Table'[Date Created]
>= DATE ( YEAR ( TODAY () ) - 1, MONTH ( TODAY () ) - a + 12, 1 ) - 1
)
)
)``````

When select last 3 months or last 4 months, the result shows:

Here is my test pbix file:

Hope this helps.

Best Regards,

Giotto Zhi

Super User

Please check the sorting column, check that is the month.

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors