Forum Discussion

Hari77's avatar
Hari77
Regular Visitor
1 year ago
Solved

Gauge chart

I have a gauge chart in my report . Where the value column has more number than maximum value .For Example , if my value is 10000 where my maximum value is 8000.I couldn't able to see the extra 2000 in my view .Is there any way to view the value which is more than maximum value. Kindly need your help.

 

Need Help
  • grazitti_sapna's avatar
    grazitti_sapna
    1 year ago

    Hi Hari77 ,

    Based on your screenshot, the gauge chart displays the "Year To Date Revenue" value of 1.82M, which exceeds the forecast target of 1.8M. Since the value exceeds the gauge's maximum (Forecast Revenue), the excess portion (0.02M) is not visually represented.

    Here’s how you can handle this situation:

    • Option 1: Dynamically Adjust the Maximum Value
      Set the gauge chart's maximum dynamically based on the "Year To Date Revenue" if it exceeds the "Forecast Revenue."
      • Step 1: Create a DAX measure to dynamically calculate the maximum valueDynamicMax =
        IF(
        MAX('Table'[Year To Date Revenue]) > MAX('Table'[Forecast Revenue]),
        MAX('Table'[Year To Date Revenue]) + 1000, -- Add a buffer
        MAX('Table'[Forecast Revenue])
        )
      • Step 2: Set this DynamicMax measure as the Maximum value in the gauge chart’s formatting options.
    • Option 2: Highlight the Gauge Overflow                                                                                                                            Add conditional formatting or a range indicator to show that the value exceeds the target.
      •  Add custom ranges for the gauge, such as:
        • Green for values up to the forecast.
        • Red or a new section for values beyond the forecast.

     

     

     

    Let me know which approach works for you

    If I have resolved your question, please consider marking my post as a solution. Thank you!

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Hari77 ,

     

    As a supplement, the Gauge Vision object does not display values that exceed the maximum limit of the gauge. The optimal solution can be to increase the maximum value of the meter chart to accommodate the highest possible value. This way, all values can be displayed in the chart.  

     

    You can try formula like below to create measure:

    GaugeMin = 0
    GaugeMax = 
VAR MaxValue = MAX('Table'[Value])
RETURN
IF(MaxValue > 8000, MaxValue, 8000)

    GaugeValue = SUM('Table'[Value])

    Best Regards,
    Adamk Kong

     

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

     

3 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    1 year ago

    Hi Hari77 - In Power BI, the gauge visual does not display values beyond the maximum limit of the gauge.

    You can create a dynamic measure for the maximum value of the gauge to ensure it adjusts based on the value column.

    Dynamic Maximum =
    MAX(
    [Target Value], -- Replace with your target measure
    [Actual Value] -- Replace with your value measure
    )

    Set this measure as the maximum value for the gauge chart in the format pane. This ensures that the gauge dynamically adjusts to accommodate values larger than the original maximum.

     

    Create a card visual or tooltip to explicitly display the actual value when it exceeds the maximum gauge value.

    Exceeding Value =
    IF(
    [Actual Value] > [Target Value],
    [Actual Value], -- Show the actual value if it exceeds the target
    BLANK() -- Otherwise, display nothing
    )

    Highlight the gauge or provide visual indicators for values exceeding the maximum. Add a color or icon in a separate table or card to indicate values exceeding the target.

     

  • grazitti_sapna's avatar
    grazitti_sapna
    Super User
    1 year ago

    Hi Hari77 ,

    Based on your screenshot, the gauge chart displays the "Year To Date Revenue" value of 1.82M, which exceeds the forecast target of 1.8M. Since the value exceeds the gauge's maximum (Forecast Revenue), the excess portion (0.02M) is not visually represented.

    Here’s how you can handle this situation:

    • Option 1: Dynamically Adjust the Maximum Value
      Set the gauge chart's maximum dynamically based on the "Year To Date Revenue" if it exceeds the "Forecast Revenue."
      • Step 1: Create a DAX measure to dynamically calculate the maximum valueDynamicMax =
        IF(
        MAX('Table'[Year To Date Revenue]) > MAX('Table'[Forecast Revenue]),
        MAX('Table'[Year To Date Revenue]) + 1000, -- Add a buffer
        MAX('Table'[Forecast Revenue])
        )
      • Step 2: Set this DynamicMax measure as the Maximum value in the gauge chart’s formatting options.
    • Option 2: Highlight the Gauge Overflow                                                                                                                            Add conditional formatting or a range indicator to show that the value exceeds the target.
      •  Add custom ranges for the gauge, such as:
        • Green for values up to the forecast.
        • Red or a new section for values beyond the forecast.

     

     

     

    Let me know which approach works for you

    If I have resolved your question, please consider marking my post as a solution. Thank you!

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Hari77 ,

     

    As a supplement, the Gauge Vision object does not display values that exceed the maximum limit of the gauge. The optimal solution can be to increase the maximum value of the meter chart to accommodate the highest possible value. This way, all values can be displayed in the chart.  

     

    You can try formula like below to create measure:

    GaugeMin = 0
    GaugeMax = 
VAR MaxValue = MAX('Table'[Value])
RETURN
IF(MaxValue > 8000, MaxValue, 8000)

    GaugeValue = SUM('Table'[Value])

    Best Regards,
    Adamk Kong

     

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