Custom visual

[afp141991]

Hello,

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

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 · Accepted solution]

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

[theBIbutler]

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....