Line chart: hide future months

[simone_g]

Hello,

I can't visualize data through a line chart correctly.

This is what I need to do:

1. Show all 12 months for each product
2. Hide the line for future months ( may 23, june 2023, etc.)
3. If in the past there were no sales for a specific month, set the line to zero

Please see the attachment.

Thank you in advance!

[MayilVahanan · Accepted solution]

Hi

Instead of 2 measure, Try like below

Dim: Month, Year
Exp: Sum(Sales )+ sum( {1} 0 )

It will help you

[simone_g]

Thank you! It was helpful! 🙂

Now suppose that I have sales data from 2021 to 2013. Is it possibile to show just the last two years in the line chart (i.e. 2022 and 2023)?

Can I hide sales data of the current month ? For example, sales data of 2023-05-01 ? I would like to hide them because the full data for the current month are not available yet.

Please see the attachment.

Thank you !

[MayilVahanan · Accepted solution]

Hi

Try like below

Sum( {<year={">=$(=year(today())-1)"}, Date={"<$(=MonthStart(Today()))"}>} Sales ) + sum( {1<year={">=$(=year(today())-1)"}, Date={"<$(=MonthStart(Today()))"}>} 0 )