Min and Max line indicator visual

[w_Das]

Hi Team,

I have previous year min and max sales volume and I have to visual like below,

Abc data and for a given Calendar year they want to see the Minimum sales and the Maximum sales and where the current and Previous sales fall on the line.

Cur.sales -> current month
Prev.Sales -> previous month

Thanks,

Wd

[v-yangliu-msft]

I’d like to acknowledge the valuable input provided by the @amitchandak . I would like to make an addition around the visual you have given.

Hi  @w_Das ,

I created some data:

Here are the steps you can follow：

1. Create measure.

You can create four indicators for visual to be placed in specific locations:

Min =
MINX(
    ALL('Table (2)'),'Table (2)'[Column1])

Max =
MAXX(
    ALL('Table (2)'),'Table (2)'[Column1])

pre =
SUMX(
    FILTER(ALL('Table (2)'),
    'Table (2)'[Group]="pre"),'Table (2)'[Column1])

cur =
SUMX(
    FILTER(ALL('Table (2)'),
    'Table (2)'[Group]="cur"),'Table (2)'[Column1])

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@w_Das , I doubt a similar visual.

You can consider bullet chart

[w_Das]

Thanks @amitchandak 

How do I showcase Prev Sales and Current sales icon or something ?

Please advise

Thanks,
Wds