Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Chart - % by Year

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 ...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    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.

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

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's avatar
    Anonymous
    Not applicable
    7 years ago
    Here is the DAX code of the measure: Donation for Pd = calculate( SUM(Donation_Distributions[Amount]))
    • v-yuta-msft's avatar
      v-yuta-msft
      Community Support
      7 years ago

      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.