Forum Discussion

mydefipet's avatar
mydefipet
New Member
3 years ago
Solved

Column Chart Randomly Skipping a Month

I'd like to show a column chart, with dates across the x-axis, and values being the running balance of a table. The running balance should show the cumulative total of values up to the end of the month shown in the x-axis. 

 

The format/shape of the image below is exactly what I want, but notice that while correctly showing 12 months, it is skipping Feb-22. 

Output - looks per expectations, but skips Feb-22

 

Below some images for the actual structure of a sample I've made. Here is a link to the sample file

IndexMonth does actually change from Jan-22, to Feb-22, to Mar-22

 

Structure of Date Table + DAX for IndexMonth.

 

 

Structure of Test Data table

 

Note that the issue persists even if I filter the visual By value RunningIndexMonth from the Test Data table, OR By value UndexMonth from the Date Table.

I must be doing something wrong with the linking/Index Month, but because everything seems to work other than specifically missing Feb-22 (and a reproducable issue because I made this sample file specifically to mirror my real file), I'm at a loss...

  • Hi , mydefipet 

    Thank you for your sample .pbix file , i download it and test in my side , i find the configuration for the topn is wrong.

    You should configure it with max/min of the [IndexMonth] , not the sum.

    After the configuration of this , it works good.

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

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

2 Replies