Percent of column total in Clustered column

[Jane24]

Hi everyone,

could you please help me to get this kind of graph?

In power BI it is possible just % of GRAND total visualization, but I need to calculate : (Amount in EUR of each currency / total amount in a month). This calculation is possible just for Matrix, but it is impossible to visualize it in a Clustered column. 

The background data looks like that:

Many thanks, I am starting to be a quite desperate :).

[v-shex-msft · Accepted solution]

HI @Jane24,

Current power bi not contains visual which support to display percent and clustered column bar at same time.

In my opinion, I'd like to suggest you use clustered column chart to create chart, then write a measure to calculate different group summary value and get percent.

Sample measure:

Percent=
DIVIDE (
    CALCULATE (
        SUM ( 'Table'[TRXamt] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            [Month] IN VALUES ( 'Table'[Month] )
                && [CCY] IN VALUES ( 'Table'[CCY] )
        )
    ),
    CALCULATE (
        SUM ( 'Table'[TRXamt] ),
        FILTER ( ALLSELECTED ( 'Table' ), [CCY] IN VALUES ( 'Table'[CCY] ) )
    ),
    0
)

Regards,

Xiaoxin Sheng