X axis is not updating to last 7 days

[naanisim]

I have a kusto query inside powerbi that is getting the correct data and shows the last seven days but when I go to look at the graph that was built in powerbi, it is not updating the x-axis and it is stuck in Setpember. I'm not sure what to do in order to fix it.

x axis: 

The data the kusto query is showing in PowerBi:

Inside the Fields section of PowerBi when looking at the graph where the x-axis is, there doesn't seem to be any errors coming up either:

[v-stephen-msft]

Hi @naanisim ,

What action did you use to make the visual show the last 7 days?

Is it possibile to provide some dummy data and expceted results?

Best Regards,

Stephen Tao

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

[naanisim]

I am getting the last 7 days by using the following in a kusto query under Power Query Editor: 
[Query=[#"csl"="let lookback=7d; ... /*goes on to the rest of the query*/ ]
And the way I get the day in the Kusto query is:

[naanisim · Accepted solution]

I figured out what the problem was. The data was refreshed to show the current dates but the graph itself also needed to be refreshed separately. Is there a button that does this all at once? Why would only the data refresh and not the graph that was using the data?

[v-stephen-msft]

Hi @naanisim ,

Glad your issue was resolved.

And there's a button for refreshing data and visuals.

Best Regards,

Stephen Tao

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

[amitchandak]

@naanisim , You can get last 7 days using a measure like

//Last 12 based on today
new measure =
var _max = eomonth(today(),0)
var _min = _max -7
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

But if you want select a value and then want 7 days, you need an independent date Table

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = _max -7
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI