Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Line Chart

Hi,

 

is it possible to get a line chart in power-bi which looks like this?

I just want to display 4 values, minimum, maximum, average and the actual value. I tried and got this output.

 

Should I add anything for the X-axis? Any help is appreciated. 



Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

    I created a sample pbix file(see attachment), please check whether that is what you want.

    1. Create a calculated column as below

    Type = 
VAR _max =
    MAX ( 'Table'[Spend] )
VAR _min =
    MIN ( 'Table'[Spend] )
VAR _avg =
    AVERAGE ( 'Table'[Spend] )
VAR _actual = 'Table'[Spend]
RETURN
    SWITCH (
        'Table'[Spend],
        _max, "Highest Spend",
        _min, "Lowest Spend",
        _avg, "Average Spend",
        "Actual Spend"
    )

    2. Create a line chart(Axis: Time Frame  Legend: Type  Values: Spend)

    Best Regards

9 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    You should not use a line chart for this purpose. Line charts suggest relationships between the data points. Your data points do not satisfy these criteria. Use a different, less misleading representation.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I understand that but Im not in a position to propose or use another visual

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

    Could you please provide some sample data(exclude sensitive) which refer in the line chart? And the legend value Lowest Spend, Average Spend and Highest Spend are from the fact field or some measures? If they are from measures, could you please provide the related formula? Thank you.

    By the way, the label of the line chart changes according to the value and cannot be customized...

    Best Regards

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi, thanks for replying.
      Please, find the dummy data. The maximum is calulcated as Max(Spend), same for min and average. They are all calculated based on the spend column.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Anonymous ,

        I created a sample pbix file(see attachment), please check whether that is what you want.

        1. Create a calculated column as below

        Type = 
VAR _max =
    MAX ( 'Table'[Spend] )
VAR _min =
    MIN ( 'Table'[Spend] )
VAR _avg =
    AVERAGE ( 'Table'[Spend] )
VAR _actual = 'Table'[Spend]
RETURN
    SWITCH (
        'Table'[Spend],
        _max, "Highest Spend",
        _min, "Lowest Spend",
        _avg, "Average Spend",
        "Actual Spend"
    )

        2. Create a line chart(Axis: Time Frame  Legend: Type  Values: Spend)

        Best Regards