Skip to main content

    Power BI

    Needs Votes

    Ability to use Trend Line with Categorical Values in X-axis

    Vote (270) Share
    's profile image

    on 26 Sep 2016 21:17:59

    Right now we can only use trend lines for continuous values in the x axis. It would be great if a categorical value could also be used, such as month name.

    Comments (37)
    's profile image Profile Picture

    9dd6cba4 8fe5-4606-ac22-1c4c00352c7f on 05 Jul 2020 23:34:36

    RE: Ability to use Trend Line with Categorical Values in X-axis

    This should be no. 1

    's profile image Profile Picture

    89468358 b24a-4943-bd64-808aa1d1d59d on 05 Jul 2020 23:32:32

    RE: Ability to use Trend Line with Categorical Values in X-axis

    Adding this functionality would greatly improve our dashboards.

    's profile image Profile Picture

    7783e6c0 e6f0-40f2-9a8b-a2fa77d9f676 on 05 Jul 2020 23:32:32

    RE: Ability to use Trend Line with Categorical Values in X-axis

    Agreed... if this can be done in Excel, Power BI should as well.

    's profile image Profile Picture

    4409bfdd b8cb-4bcb-809b-3e265e87d0b9 on 05 Jul 2020 23:31:46

    RE: Ability to use Trend Line with Categorical Values in X-axis

    This is a must in our organization

    's profile image Profile Picture

    0bedc085 e98f-4c48-8d60-180e20ab282c on 05 Jul 2020 23:31:41

    RE: Ability to use Trend Line with Categorical Values in X-axis

    Anything you can do in Excel, Power BI should be able to replicate.

    's profile image Profile Picture

    b2b9291b 96ee-4d52-8079-fa49c2c6f1a8 on 05 Jul 2020 23:27:32

    RE: Ability to use Trend Line with Categorical Values in X-axis

    Users expect to be able to use that from the Excel.

    's profile image Profile Picture

    d88a06b4 f76b-4a3b-a75f-022a8a740d7d on 05 Jul 2020 23:25:04

    RE: Ability to use Trend Line with Categorical Values in X-axis

    Trend line for week should be available.

    's profile image Profile Picture

    e7336bd6 080e-4641-a1ab-f5596622f65c on 05 Jul 2020 23:21:18

    RE: Ability to use Trend Line with Categorical Values in X-axis

    Definitely a requirement for categorical value. Having to resort to Excel for certain visuals with trend lines which I really want to get away from.

    's profile image Profile Picture

    06b35ebb ac3a-473f-bd05-1ec95c8d5c15 on 05 Jul 2020 23:09:23

    RE: Ability to use Trend Line with Categorical Values in X-axis

    Shocked to learn I can't have a trend line for a date hierarchy of Year, Quarter, Month. If I start on Year show the trend line for the years and then show trend line as I drill down to Quarter and Month. Please implement this!

    's profile image Profile Picture

    3ad5368f 844b-4cd8-bbd8-35b77376b31d on 05 Jul 2020 23:07:23

    RE: Ability to use Trend Line with Categorical Values in X-axis

    Agree that this is required functionality: It doesn't make sense for the trend line to only be available with a Continuous X-Axis.