Forum Discussion

Jo_Chrq's avatar
Jo_Chrq
Helper I
2 years ago
Solved

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. Eac...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.           

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.