Forum Discussion
Gauge Visual - Applicable or not?
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.
Anonymous given the sample data in your post, is this what you are looking for?
4 Replies
- parry2k
Super User
Anonymous given the sample data in your post, is this what you are looking for?
- parry2k
Anonymous 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.⚡