Forum Discussion

swestendorp's avatar
swestendorp
Helper I
8 years ago

Graph shows rolling average for future months

Good day all,    I can't wrap my head around the following issue. I've created a rolling 30 day measure. When visualing in a graph, values are shown for future months (when I use the date hierarchy...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi swestendorp,

 

You said "Obviously, I don't want these to be shown. How can I solve this? Your help is highly appreciated!"

<--- Which column is used as X-axis in your chart? Could you give some more details about your table structure and expected requirement? And if possible, can you provide a pbix file with dummy data for further analysis?

 

Regards,

Jimmy Tao

  • swestendorp's avatar
    swestendorp
    Helper I
    8 years ago

    Hi v-yuta-msft,

     

    Thanks for your reply. In the meantime, we have found out that it has something to do with the last step, that is the '1 - ...'. This is causing Power BI to calculate for future months. I don't know however to solve this. 

     

    On the X-axis I have used my date table: 

     

    Dates =
    CALENDAR ( DATE ( ( 2013 ), ( 01 ), ( 01 ) ), TODAY () )

     

    My data model looks like this:

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Thanks for your help.

     

    Best regards,

    Sifra