Chart with last 4 weeks' data and secondary chart with just last week's data

[Anonymous]

Hello! This is my first forum post so please be understanding if I post too much info, I want to be 'easy' to help 🙂

I am trying to show 4 weeks of data in a chart, which is easy, but on the same power bi page in a different chart, show the most recent week worth of data too. I have the data automatically uploading from a database source.

The data I have currently looks like this in my query, with the current chart showing the equipment name on x axis, and the OEE percentages on Y. There is a slider that is linked to Shift ISO column so that the last 4 weeks of data can be displayed. 

Is there any way to make a chart that only shows the last week's worth of data based on the time of accessing the power bi? thank you!

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can create a measure, measures can change dynamically with filtering

Measure SUMX(FILTER('Table (2)','Table (2)'[Shift ISO Week of Year]=WEEKNUM(NOW(),2)-1),[%OEE])

This measure is to filter out the list based on the time before to find the relevant value of the previous week

Then create the chart and put the measure in Y axis, the values of the previous week are displayed

^{Best Regards,}

^{Yolo Zhu}

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