Forum Discussion
Price range comparison graph
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
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.
3 Replies
Hi, thanks for your response. Unfortunately, it only seems to be working with dates, and not amounts
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.
