Visualization help based on 3 data points

[SK28]

Hi Team,

Can anyone help with below mentioned requirement please

I have 3 Data points( YR 2022, Current Status, YR2023) as shown below

Program	YR 2022	Current trend	YR 2023 (target)
ABC	90%	92%	95%
bcd	80%	82%	95%
def	8	11	20

I need a visualization based on above sample data as shown below

Kind of any box plot with a Straight line - 90%

a box which shows the Current value - 92%

and a line which has 95%

or any such kind of viz which has a 

Single Viz for each row also works for me, can anyone suggest me how can this be achieved please.

[N30fyte · Accepted solution]

One way would be a Gauge chart for each Program, with the display set to a horizontal bar:

The Measure (KPI) for the first chart is:

{<Program={'ABC'}>} Current_trend

In the Range for this chart, the Minimum is an expression:

={<Program={'ABC'}>}[2022]

and the Maximum is also an expression:

={<Program={'ABC'}>}[2023_(target)]

(I've modified the names of the fields slightly.)

These are the display settings for the charts:

The expressions in the second chart follows the same pattern as the first with 'bcd' replacing 'ABC'.

With a lot of programs this would soon become very tedious to set up 😉

So you might be able to create a single chart combined with a filter pane and use GetFieldSelections in the expressions to switch displays between the individual programs. But my set expression skills aren't quite up to that I'm afraid...