Gauge Visual - Applicable or not?

[AliRade]

Hi Community,

I'm trying to use the Gauge Visual for a set of data but its not coming up how I want it. I think I'm not doing it correctly as opposed to its not possible with Gauge Visual...(I'm not 100% sure).

Bacially, say I have 100 records (rows) and for one of each of them I have Status colum which has certain values (i.e. 1-Complete, 3-Error, 0-Not Complete).

Item (Record)	Status
1	0
2	0
3	1
51	1
81	3
91	3
100	1

Say for exampe for 100 records, I have 60 that are Status 1 (Complete), 30 are Status 0 (Not Complete), and 10 are 3 (Error)

I'm trying to have the Gauge show for those 100 records, how many still need to be Status "1" (all 100 records targetting to be '1'). i.e. if i ignore the 10 records which are 3 (error), the gauge will show 60/30 split.

Is it possible to achive the output using gauge visual? I can picture it in my head but stuggling to get it working in the application.

[parry2k]

@AliRade see page 8 and table gauge in attached file. There are many other tables in the file, just ignore those.

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[AliRade]

Thank you. Very clear with your examples. Much appreciated 🙂

[parry2k · Accepted solution]

@AliRade given the sample data in your post, is this what you are looking for?

[AliRade]

Hi parry2k,

Yes...this kind of Gauge output is how i have pictured in my head! 🙂

Do you mind sharing the pbix so I can see how you set it up?

Thanks in advance for your help