Price range comparison graph

[Jo_Chrq]

Hi,

I'm looking for a type of graph in PBI Desktop that I can't seem to find.

Anyone has an idea?

I have a group of individuals whom each has several cards with several amounts on them.

Each person also belongs to a diffenrent category.

I'm trying to represent on a graph, per category, the minimum and maximum amount each person has, and reproduce the following graph that I did on Excel:

Is it doable on PBI Desktop?

Many thanks in advance

jo

[Anonymous · Accepted solution]

Hi @Jo_Chrq ,

There is no suitable visual, but as a workaround. You can create a stacked bar chart and then set the bar in the front section to white.

Sample data:

Stacked bar chart:

If you find that the maximum value corresponds to the wrong x-axis value, you can create an interval measure to replace the max value column.

Interval = SUM('Table'[Max])-SUM('Table'[Min])

As you can see, for C2, the max value is 38, which is displayed correctly below.

Best Regards,

Stephen Tao

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

[Uzi2019]

Hi @Jo_Chrq 
Please try Gantt chart by Microsoft from App source.
Your chart is similar looking of gantt chart.

If my post helps pls give kudos and accept it as a solution!
Thanks

[Jo_Chrq]

Hi, thanks for your response. Unfortunately, it only seems to be working with dates, and not amounts