Forum Discussion

BobPierre's avatar
BobPierre
Frequent Visitor
8 years ago

STACKED CHART

Good day good people.

I am new to Power BI. I have a set of data that I want to display like this: To display Percentage of column total.

 

The excel is the way the data loaded into Power Bi looks like.

 

Thank you all in advance.

 

 

4 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    8 years ago

    Hi BobPierre,

    Based on my test, you can refer to below steps:

    1.I have entered some sample data like the picture below:

    2.Create a measure.

    MeasureA = (CALCULATE(SUM(Table1[Value]),FILTER('Table1','Table1'[Compliance Rate]=MAX('Table1'[Compliance Rate])&&'Table1'[Transpoter]=MAX('Table1'[Transpoter]))))/CALCULATE(SUM(Table1[Value]),FILTER(ALL('Table1'),'Table1'[Transpoter]=MAX('Table1'[Transpoter])))

    3.Create a Stacked column chart and add the related field. Now you can see the correct result.

     

    You can also download the PBIX file to have a view.

    https://www.dropbox.com/s/ew4wb604joyxzeb/STACKED%20CHART.pbix?dl=0

     

    Regards,

    Daniel He

    • BobPierre's avatar
      BobPierre
      Frequent Visitor
      8 years ago

      Thanks for your response.

      But my data does not have value, so, I am a bit confused.

       

      • v-danhe-msft's avatar
        v-danhe-msft
        Microsoft Employee
        8 years ago

        Hi BobPierre,

        To find the cause as soon as possible, I would suggest you share pbix file if possible. If the report does contain sensitive data, please upload your report to your OneDrive and send the link to me via private message.

         

        Regards,

        Daniel He