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

 

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.

3 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity 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
        Icon for Community Support rankCommunity 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.