Forum Discussion

afp141991's avatar
afp141991
Frequent Visitor
9 years ago
Solved

Custom visual

Hello,

 

I want to display a particulart chart but I don't know if there is any visualization that can help me:

Chart example

As you can see, I want to display the different categories of clientes according to the number of clients in each category. For example, category A may have 10 clients, whereas category E can have 50 clients. The sum of A, B, C, D and E does not represent the total number of clients, because one client can be in different categories at the same time. 

 

 

Any idea if there is any visualization to represent this chart?

 

Many thanks!

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

    Hi afp141991,

     

    In Power BI, there is no such a visualization can represent data like above chart. To work around this, please try to create a calculate table. Table1 is the original table containing two columns [Category] and [Client].

     

    Table2 =
UNION (
    SUMMARIZE (
        Table1,
        Table1[Category],
        "Client", DISTINCTCOUNT ( Table1[Client] )
    ),
    SUMMARIZE (
        SELECTCOLUMNS (
            Table1,
            "Category", "Total Client",
            "Client", DISTINCTCOUNT ( Table1[Client] )
        ),
        [Category],
        [Client]
    )
)

    Then, create a column bar chart like below, add fields from Table2.

     

    Best regards,
    Yuliana Gu

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    Hi afp141991,

     

    In Power BI, there is no such a visualization can represent data like above chart. To work around this, please try to create a calculate table. Table1 is the original table containing two columns [Category] and [Client].

     

    Table2 =
UNION (
    SUMMARIZE (
        Table1,
        Table1[Category],
        "Client", DISTINCTCOUNT ( Table1[Client] )
    ),
    SUMMARIZE (
        SELECTCOLUMNS (
            Table1,
            "Category", "Total Client",
            "Client", DISTINCTCOUNT ( Table1[Client] )
        ),
        [Category],
        [Client]
    )
)

    Then, create a column bar chart like below, add fields from Table2.

     

    Best regards,
    Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    I would split the visual into two; have one visual (card) for the unique total of clients and then a stacked bar chart, sorted in descending order of number of clients with category on the axis.

     

    The way you have it you can't easily compare the number of clients in each category....