locked
How to customize X-axis of Power BI Dashboard? RRS feed

  • Question

  • I want to show on Power BI Dashboard a moving average - for example, I want to always show 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


    -- Predict everything. http://www.predixionsoftware.com

    Wednesday, August 26, 2015 3:50 PM

Answers

  • Thanks everyone. The trick is to use a GROUP BY TumblingWindow and that seems to solve the problem.

    -- Predict everything. http://www.predixionsoftware.com

    • Marked as answer by Charlie Liao Tuesday, September 8, 2015 2:08 AM
    Thursday, August 27, 2015 9:51 PM

All replies

  • Hi Chu,

    According to your description, you need to customize X-axis for your Power BI chart because of that it makes the dashboard ugly to display all the value on X-axis, right?

    You can use FILTER to filter the values on X-axis. In the PivotChart Filter Pane, click the arrow on Axis Fields (Categories)or Legend Fields (Series). Tip   To change the field without closing the Filter menu, in the Select fieldbox at the top, select a field from the drop-down list. Please refer to the link to see the details.
    https://support.office.com/en-nz/article/Filter-data-in-a-PivotTable-or-PivotChart-report-ca3ae673-95ac-46ab-b31a-7e3c5265c422
    http://www.dummies.com/how-to/content/how-to-customize-your-excel-pivot-chart-and-axis-t.html

    Regards,


    Charlie Liao
    TechNet Community Support

    Thursday, August 27, 2015 9:21 AM
  • 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.

    • Proposed as answer by greggyb Thursday, August 27, 2015 7:31 PM
    • Unproposed as answer by Chu Xu Thursday, August 27, 2015 9:51 PM
    Thursday, August 27, 2015 11:45 AM
  • Thanks everyone. The trick is to use a GROUP BY TumblingWindow and that seems to solve the problem.

    -- Predict everything. http://www.predixionsoftware.com

    • Marked as answer by Charlie Liao Tuesday, September 8, 2015 2:08 AM
    Thursday, August 27, 2015 9:51 PM