Chart - % by Year

[Anonymous]

I have a visual in Power BI with a table on top and chart below it.  On the table, I can show the % as a % of Column but in the Chart it is showing the % as a % of Grand Total for the 2 Years I have selected.  How can I show the %'s in the chart to mirrow what is in my table (as of % of total for each individual year)?  I have attached a screenshot of what I have.  Thanks!

[v-yuta-msft]

@Anonymous ,

Seems like "%GT Donation for Pd" is a measure, this issue should be related to the measure. Could you share the dax code of the measure?

Regards,

Jimmy Tao

[Anonymous]

Here is the DAX code of the measure: Donation for Pd = calculate( SUM(Donation_Distributions[Amount]))

[v-yuta-msft · Accepted solution]

@Anonymous ,

Please modify your measure using dax below:

Result =
CALCULATE (
    SUM ( Donation_Distributions[Amount] ),
    ALLEXCEPT ( Table, Table[Payment Type], Table[Year] )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.