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

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi, is there any way to achieve the below visual with the same dataset as above? Thanks again