The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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:
Solved! Go to 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?
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.
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:
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?
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.
@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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
248 | |
123 | |
111 | |
78 | |
74 |