Forum Discussion

Rustami4's avatar
Rustami4
Helper II
8 years ago
Solved

percentage

Hi everyone,

 

I've got the following situatuion..

I think i need some measure to express what i want.

I have 2015 and 2016 years depicted like legends, differently they grafically look like two columns (2015&2016). Every of year has a special markings (TD, DTF, BHA and ect). I need to express the percentage "TD" value relatively other markings in every column. So it should be looked like..just for example.. 40%&55% (2015&2016) for "TD"

Please I need your help..I'm not as good at this as most of you

Need Help

13 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    HI Rustami4

     

    Could you please post a mockup of your expected result.  Perhaps use Excel to make something like you are trying to achieve in Power BI.

    • Rustami4's avatar
      Rustami4
      Helper II
      8 years ago

      this is what i want to see, but i wanna see each of them expressed as a percantage ratio of the total number of all cases

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Rustami4,

        Please check if "pecent of grand total" option meets your requirement, if not, check my DAX in this similar thread.


        If you still have questions, please share dummy data of your table and post expected result.

        Regards,
        Lydia