Line stacked chart repeating x-axis columns

[kala2]

Hello,

I have the following stacked line chart which has been drilled down to year and month in order to show Sum of costs.



Each category is a running total of costs per month 

I have created a Running total column

SUMX (
    FILTER (
        Table1,
        EARLIER ( Table1[Group] ) = Table1[Group]
            && EARLIER ( Table1[Index] ) >= Table1[Index]
    ),
    Table1[Amount]
)

Is there a way to prevent the repeating columns? 

Any ideas would be helpful! Thanks!

[v-yanjiang-msft · Accepted solution]

Hi @kala2 ,

According to your description, the visual show the running total value, I think when the [Amount] is 0 caused the repeating columns.

You can modify the formula like this:

Column =
VAR _Total =
    SUMX (
        FILTER (
            Table1,
            EARLIER ( Table1[Group] ) = Table1[Group]
                && EARLIER ( Table1[Index] ) >= Table1[Index]
        ),
        Table1[Amount]
    )
RETURN
    IF ( Table1[Amount] = 0, BLANK (), _Total )

Best Regards,
Community Support Team _ kalyj

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

[TheoC]

Hi @kala2 

You should be able to go to the visual and use the Filter Pane to hide any Date period that you do not want or you can use Relative Date in the filter pane to limit the periods you want to show.

1. Click on the visual.
2. Go to the Filter pane.
3. Click on Date.
4. One here, you can click on Filter Type and select the approach you want to take.

Hope this helps.

Theo