Restrict values to be shown on x-axis

[Nickolay1]

Hi all,

I would appreciate if you could help me with this one. Based on the attached file I need to have a chart that has dimension for x-axis from the column Next 3 months. But the dimensions should be limited only to cells that are in the same row with the cells 01.01.2023 from the column Data Month – Year (current cycle). I.e. on the x-axis we should have Feb, Mar and Apr. This file will be appended every month and therefore Next 3 months dimension should be dynamic, i.e. always linked to the current cycle. Column Next 3 months will be populated accordingly. Therefore during the next cycle (Data Month – Year  01.02.2023) x-axis should have Mar, Apr and May.

[KGalloway · Accepted solution]

Would something like the following work?

I used a dimension value =if(year([Data Month - Year]) = year(today()) and month([Data Month - Year]) = month(today()), [Next 3 Months])

I put in a dummy measure = 3.

[Nickolay1]

Thanks a lot! It works perfectly 🙂