Forum Discussion

otaylor67's avatar
otaylor67
New Member
8 years ago
Solved

Grouping in a Pie Chart

Hello - 

 

I am trying to create a Pie Chart that breaks out servers availability % per month. I know the interface name and the % Available from a Solarwind SQL query. But when I try to place them on a pie chart I get all the interfaces which is too much information to relevant. So I want to group servers by an availability % ranges say Group A: 100% Group B: 90% - 99.99 ... etc. Is this possible in Power BI to arrange them like so after I get the data back from the SQL call to Solarwinds database?

 

Thanks,

 

Orlando

  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi otaylor67,

     

    You could create a calculated column with below similar formula:

    New Group =
IF (
    Table2[ % Available ] = 1,
    "GroupA",
    IF (
        Table2[ % Available ] >= 0.9
            && Table2[ % Available ] < 1,
        "GroupB",
        IF (
            Table2[ % Available ] >= 0.8
                && Table2[ % Available ] < 0.9,
            "GroupC",
            "GroupD"
        )
    )
)

    Best regards,

    Yuliana Gu

2 Replies

  • otaylor67's avatar
    otaylor67
    New Member
    8 years ago

    Hello - 

     

    I am trying to create a Pie Chart that breaks out servers availability % per month. I know the interface name and the % Available from a Solarwind SQL query. But when I try to place them on a pie chart I get all the interfaces which is too much information to relevant. So I want to group servers by an availability % ranges say Group A: 100% Group B: 90% - 99.99 ... etc. Is this possible in Power BI to arrange them like so after I get the data back from the SQL call to Solarwinds database?

     

    Thanks,

     

    Orlando

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi otaylor67,

     

    You could create a calculated column with below similar formula:

    New Group =
IF (
    Table2[ % Available ] = 1,
    "GroupA",
    IF (
        Table2[ % Available ] >= 0.9
            && Table2[ % Available ] < 1,
        "GroupB",
        IF (
            Table2[ % Available ] >= 0.8
                && Table2[ % Available ] < 0.9,
            "GroupC",
            "GroupD"
        )
    )
)

    Best regards,

    Yuliana Gu