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: As you can see, I want to display the different categories of clientes according...
  • 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

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