How to customize X-axis of Power BI Dashboard?

[gohawks3]

I want to show on Power BI Dashboard a moving average - for example, I want to always show real-time the last 30 measurement of body temperature but it looks like Power BI dashboard shows all measurements I have and compress them - which makes the dashboard ugly. I tried to customize the X-axis properties but I dont know what I should change the default start/stop properties to (where the default property value is automatic).

Thanks!

Chu

[Greg_Deckler]

In your data model, add a caculated column:

=DATEDIFF([date],TODAY(),DAY)

[date] is your datetime column in your data set.

Then, just add a filter based on this new column in your visualization so that it is greater than or less than some number that you like. Bingo, rolling date x-axis.

[Seth_C_Bauer]

@gohawks3

Can you accomplish this by using filtering... It sounds like you already know your last 30, so either use an existing column or create a calculated column and filter by where field is greater or = 30