Looking for a way to replicate this viisual (dial with 5 coloured "zones")

[Moehimby]

Hellp BI enthusiasts, I've come again to pick your brains.

Company has completed a big customer survey and I've been tasked with presenting the results dynamically in BI. 

Does anyone know how I could recreate the visual pictured here? It is currently a dial with 5 coloured "zones" for "Very Disatissfied" , "Disatisfied", "Neutral" , "Satisfied", "Very Satisfied" so a total of 5 zones each having it's own range. I've looked around for other dial or guage visuals but have only found dials that allow for 3 colured zones and no more.

Perhaps someone here knows of other available visuals, ways to recreate this with on-hand tools in BI, or perhaps even another visual like a bar or line that would work as a replacement?

Thanks in advance for any help you can give me.

[v-linyulu-msft · Accepted solution]

Thanks for the reply from lbendlin  please allow me to provide another insight:

Hi, @Moehimby 

Could you please let us know if lbendlin's response resolved your issue? If it did, kindly accept it as the solution.

Regarding the issue you raised, my solution is as follows:

You can try the following customisation to adjust the colours to achieve your desired results:

Secondly, you can represent the data according to your needs, as illustrated in the example below:

Here is my sample data:

Firstly, if you need to calculate the average satisfaction rating, you can create the following calculated column:

Column =
SWITCH (
    TRUE (),
    'Table'[Comtext] = "Very Disatissfied", 20,
    'Table'[Comtext] = "Disatissfied", 40,
    'Table'[Comtext] = "Neutral", 60,
    'Table'[Comtext] = "Satisfied", 80,
    'Table'[Comtext] = "Very Satisfied", 100
)

Here are the example results:

Secondly, if you wish to return the percentage of the most frequent ratings or the proportion of ratings that are Neutral or above, please refer to the following measure:

MEASURE = 
VAR Very_Disatissfied1 =
    CALCULATE (
        COUNT ( 'Table'[index] ),
        FILTER ( 'Table', 'Table'[Comtext] = "Very Disatissfied" )
    )
VAR Disatissfied1 =
    CALCULATE (
        COUNT ( 'Table'[index] ),
        FILTER ( 'Table', 'Table'[Comtext] = "Disatissfied" )
    )
VAR Neutral1 =
    CALCULATE (
        COUNT ( 'Table'[index] ),
        FILTER ( 'Table', 'Table'[Comtext] = "Neutral" )
    )
VAR Satisfied1 =
    CALCULATE (
        COUNT ( 'Table'[index] ),
        FILTER ( 'Table', 'Table'[Comtext] = "Satisfied" )
    )
VAR Very_Satisfied1 =
    CALCULATE (
        COUNT ( 'Table'[index] ),
        FILTER ( 'Table', 'Table'[Comtext] = "Very Satisfied" )
    )
VAR mm1 =
    MAXX (
        { Very_Disatissfied1, Disatissfied1, Neutral1, Satisfied1, Very_Satisfied1 },
        [Value]
    )
VAR mm2 = Satisfied1 + Very_Satisfied1 + Neutral1
RETURN
    DIVIDE ( mm2, COUNTROWS ( 'Table' ) ) * 100

Here are the example results:

Of course, if you have any new ideas, you are welcome to contact us.

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

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

[Moehimby]

Thanks! I gave this a thumbs up because it is helpful and a good solution. I'll give this a try.

[lbendlin]

It looks cute, and can be done in Deneb*, but what's wrong with a simple card visual ?

* Radial Plot | Vega-Lite

[Moehimby]

> what's wrong with a simple card visual

I'd considered this, but I'm trying to replicate what used to be a manual projust that was done by creating static images of those dials into a powerpoint - so have something as slick and "cute" but dynamic in BI would blow some socks off.

I did find a "tachometer" visual that seems to be doing the trick, but thanks for introducing me to the world of Deneb I hadn't seen it until you mentioned it.