Forum Discussion
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 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!
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
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.
- Click on the visual.
- Go to the Filter pane.
- Click on Date.
- One here, you can click on Filter Type and select the approach you want to take.
Hope this helps.
Theo
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
