Forum Discussion

kala2's avatar
kala2
Helper III
4 years ago
Solved

Line stacked chart repeating x-axis columns

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 hav...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    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's avatar
TheoC
Community Champion
4 years ago

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