Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Line Chart help please

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? 

Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    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.

    Then please try this measure:

    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:

    pbix 

    Hope this helps.

     

    Best Regards,

    Giotto Zhi

     

2 Replies

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Community Support
    6 years ago

    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.

    Then please try this measure:

    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:

    pbix 

    Hope this helps.

     

    Best Regards,

    Giotto Zhi