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. ...
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

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