Best option for replacement/update for the original Gauge visual

[Mk60]

I am looking for any suggestions for a possible replacement/update/upgrade to my old Gauge visual that I am using from last year, to perhaps use some new ones that could be even better option for this kind of tracking. Any suggestions would be greatly apprecited.

I am providing these samples for the context and the reference. In the first picture I have calculated Measures 1-9 and each has defined thresholds that need to be monitored and tracked, currently by the Quarter. Second picture, I am including examples of my existion visuals just for the first two metrics to show you what I am currently using. As you can see all calculated measure are setup with conditional formatting so you can see colors and the required zones are working fine and matching colors based on the assigned values. My only question - is there any other visual, perhasp much better or just different one that I could consider and is perhaps better fit for this type of data. Thanks so much for any ideas or suggestion in advance.

[v-kpoloju-msft]

Hi @Mk60,
Thank you for reaching out to the Microsoft fabric community forum. Thank you @Ritaf1983, @DataNinja777, for your inputs on this issue.

After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have used it as sample data on my end and successfully implemented it.    

Choose Your New Visual: Go to Power BI Visual Marketplace (… in Visualizations pane) and install one of: Option A: Bullet Chart by OKViz. Search: "Bullet Chart by OKViz"
Supports:

• Target values
• Threshold ranges
• Compact and readable layout

Option B: Linear Gauge by MAQ Software: Search: "Linear Gauge by MAQ Software"
Supports:

• Custom thresholds
• Smooth colour zoning
• Clean linear design

STEP 4: Configure the Bullet / Gauge Chart: In Bullet Chart settings, map the fields like this:

• Value: Value
• Target: Appetite
• Minimum: 0
• Maximum: Limit Max

I am also including .pbix file for your better understanding, please have a look into it:

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.

[Mk60]

Hi @v-kpoloju-msft 

Thank you so much for your sample and suggestions. So not sure you saw my response to @Ritaf1983 and @DataNinja777 it appears I ca only download temporary Bullet Chart by OKViz? Regardless, I looked at your sample for Metrics 1-5, and in the format I did not see options to use my 4 colors? Not sure I fully explained, but colors for my thersholds are assigend and I have to use those explicitely. So I do have my data table with all conditionl formatig working fine, but for my Gauge visual I just used random colors bc I could not set it up with my 4 colors appropriately, when I did it last year for the first time. Althought my Gauge visuals are working ok for now, I wish I can setup my 4 colors with the bullet chart. Maybe I just don't know, but my Bullet chart icon is different from what you have in your PBI example?

Yours: 

My PBI when I Added this visual? 

So for additional reference, here's one page of my report with actual Metrics and the Threshold zones based on the 4 colors determined by the company. This all works fine, simple table visual with conditional formating, (hiding column/metrics names).  

This is my secong page with all Gauge visuals where usaers can select month and see all Metrics, with acctal data and the thresholds variance, etc. I woud prefer to replace this page with nicer visuals to perhaps replace Gauge with new ones? So if I can setup Bullet Chart with these 4 colors I'd love to try it, but I am affarid I can't get the same version you have perhaps of my corporate PBI tenant, or some admin access??

So here's my page, (I am hiding Title and just leaving subtitle for the reference). Can I get bullet Chart showing Greem for Appetite levels, yellow for Watch, orange for Caution and red for Limit? Thanks bunch!

[Mk60]

Hi @v-kpoloju-msft 

I trully apprecite your suggestion but I do not see this working in my case? In your sample with the switch calculation you created new table to be used, in order to create a single column visual for all metrics. I am not sure I can build separate table for all metrics in my model which is just over 5MM records and growing. Another challange for me is that my risk thresholds are not just a single number, (like Target in your example), instead those are range of values, like in this table I attached before.

I feel bullet chart might be a good replacement for gauge only if I can have options to setup colors as needed. Regardless, I would be happy to accept your suggestion as a solution since I would assume that might work for some users just fine. I would still try to explore your option with buiding separate table and see if a single column visual might work. So much apprecite all the time and the help. Perhaps I am looking for something that does not exist at the moment, or not providing best explanantions without sharing my data 🙂 

Best regrads,

Mk

[v-kpoloju-msft]

Hi @Mk60,

Thanks again for your thoughtful response and for sharing more context—totally understandable that working with a large model and range-based thresholds adds complexity.

To better assist you (or explore alternative solutions that fit your specific setup), it would really help if you could provide a sample dataset that illustrates the structure of your metrics and thresholds. It doesn’t need to be your real data just a simplified, representative version that captures the issue clearly.

• Provide the data in a usable format (e.g., pasted table or downloadable file not a screenshot).
• Avoid including any sensitive or unrelated information.
• Include an example of the expected outcome based on the sample.

Need help uploading sample data?
How to provide sample data in the Power BI Community

Want tips for faster answers?
How to Get Your Question Answered Quickly

Thank you for your understanding and participation.

[v-kpoloju-msft · Accepted solution]

Hi @Mk60,

We have not yet received a response regarding our previous reply and would like to check if your issue has been resolved. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thankyou.

[Mk60]

Hi @v-kpoloju-msft 

Thank you for your followup and your suggestions, I trully apprecite it! Unfortunately I decided to stick with my original gauge visuals, at least for the time being, as I could not figure better visual option, at least for now. It would be very time consuming for me to try to use my actual data to provide a meaningfull sample for you, and preserve confidentiality of my data. I will consider looking into that as time allows using your link above. I never provided pbi sample here, so that will be something new for me to try, so thank you for that link.  However, as I stated before, in the meantime I'd be happy to accept your solution, and give you kudos since I belive it might still provide some tips and help to some other members, although I could not make it work in my case at the moment. Kind regards!

[v-kpoloju-msft]

Hi @Mk60,
Thank you for your thoughtful response and kind words.

It is completely understandable that you prefer to stick with your current visuals, especially given the time and confidentiality constraints related to sharing sample data. I am glad to hear that the shared resources were potentially useful, and I hope they can serve as a reference if you decide to explore alternative approaches in the future.

I also appreciate your willingness to accept the solution and offer kudos, as such support helps others browsing the forum learn from the discussion, even if the exact implementation did not work for your scenario.

If you decide to experiment with providing a PBI sample, feel free to reach out. I am happy to assist you with anonymizing and setting it up in a simple way. Best wishes for your ongoing project.

Thank you for using the Microsoft Community Forum.

[Mk60]

Hi @v-kpoloju-msft 

Thanks a lot for your kind words, and your willingness to help in the future with this issue. I will kepp that in mind for sure. Your generosity with your assistance is so much apprecited!

I was just about to post another question to the community, which is litteraly part of this project but completely different issue/question, so please let me know if I could post it in this chat so you can see it right away, or it would be better to do it under different title as a new post? Question is about how to show icons arrows in the Matrix visual, showing directions for QoQ and YoY changes? Thanks in advance!

[v-kpoloju-msft]

Hi @Mk60,

After thoroughly reviewing the details you provided, I reproduced the scenario again, and it worked on my end. I used it as sample data and successfully implemented it.

outcome:

I am also including .pbix file for your better understanding, please have a look into it:

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.

[Ritaf1983]

Hi @Mk60 

Gauge visuals are not ideal for effective data communication:

• The arc grabs attention, but the actual value (needle) is secondary.

• It's difficult to estimate values accurately on a curved scale.

• It consumes too much space for a single data point.

If you're only showing actual vs target, a bullet chart is a better fit – more compact and precise. You can either use a custom visual or build it manually.

Videos about this method :

https://www.youtube.com/watch?v=ymIVle3UXvA

https://www.youtube.com/watch?v=F2Q9v0tkyW0

https://www.youtube.com/watch?v=QcHeq5nJUTc

However, in your case, it looks like you're tracking more than just target achievement – including trends over quarters and changes from previous periods. That requires a different structure.

I’d recommend a table-based layout with:

• Latest quarterly value

• Variance from target (with red/orange indicators – no need to highlight green)

• % change vs previous year or quarter

• Small trendline (sparkline) for historical context

This helps users quickly focus on where attention is needed without scanning every metric in detail.

 Just note: building a proper version of this – adapted to your business logic, KPIs, and visual language – is a few hours of solid work. It’s not something that can be delivered within a forum reply. The visuals I attached are just style references from my own work.

Each of my examples focuses on a different visual element (trend, delta, risk indicator, etc.), so for your use case you'd likely need to combine several of them into one coherent layout .

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

[Mk60]

Hi Rita, thank you for your suggestions. It appears I can not get some of the suggested visuals for free?  I will watch the videos you suggested, and perhaps get an idea for some custom build visual. To your point, I DO have my table that I created with all conditional formatting, where all colors are metching defined zones and thresholds, so that works. I just wanted to try some different, perhaps better options for the visuals. I will attach some picture later here to respond to the other two response from @DataNinja09 and @v-kpoloju-msft for their suggestions and recomandations. Thaks much again

[DataNinja777]

Hi @Mk60 ,

A good replacement for your current gauge visual would be a bullet chart or a linear gauge, both of which offer better clarity and use space more efficiently. The bullet chart in particular is a great option when tracking metrics like yours with defined thresholds and conditional formatting. Instead of using a semicircle to show value against a scale, the bullet chart displays the actual value as a bar against a background showing performance zones (like risk appetite and limits), with a line marker indicating the target or threshold. This makes comparisons across multiple KPIs much easier and visually intuitive.

In Power BI, you can use the custom visual “Bullet Chart by OKViz” or similar visuals to implement this. You define your actual value, target, and qualitative ranges directly in the fields pane. Here’s a basic setup:

Actual = [Your_Measure]
Target = 0.25  // example for 25% risk appetite threshold
Range1 = 0.25  // below appetite
Range2 = 0.35  // between appetite and limit
Range3 = 1     // above limit

Then in the bullet chart visual, assign Actual to Value, Target to Target Value, and define Range1, Range2, Range3 as the qualitative bands. You can color code these ranges (light blue, gray, red) to mirror the zones in your original gauge.

For linear gauges, “Linear Gauge by MAQ Software” lets you do something similar but in a more horizontal form. These are easier to compare across multiple metrics and work well when stacked.

If you're tracking 9 measures per quarter, consider using a matrix visual with conditional formatting to show performance at a glance. You can set up a measure that returns a color-coded value based on your thresholds:

Formatted Value = 
SWITCH(TRUE(),
    [Your_Measure] <= 0.25, "Green",
    [Your_Measure] <= 0.35, "Orange",
    "Red"
)

Apply this to background color formatting in your matrix visual. This way, the user gets a compact, color-based overview without overwhelming visuals, while still preserving all the information your gauges are trying to communicate.

Best regards,

[Mk60]

Hi @DataNinja777 

As I mentioned earlier to Rita, I am not sure I can use Bullet Chart by OKViz by directly asigning my values manually. So it looks like you're suggesting creating my custom build table with all the values, right? I have already created calculated measures to define my zones, where each Metric has unique values. So I was creating my table visuals and my Guges all by using conditional formatting, withough customized table with values. Just FYI, here's one example of my first Measure, which is similar to your suggestion. I'lll try to take another look at this but for the time being I might just keep using my Guge visuals for now. Thanks much again.