Display Percentage on Y Axis and Year/Month?

[Anonymous]

I'm working on a line chart that has Date on the X-Axis and I want Basic Margin Percentage on the Y-Axis (to be displayed as a percentage). I formatted as a percentage in my Query model (I did the calculated column of Basic Margin/Revenue). I can't get it to format correctly on the Y axis as showing as a percentage. It looks like it wants to aggregate. On values, it says "Sum" for the percentage and there is no ability to not aggregate. I am new to PowerBI. Thanks for your help. 

Also, I had Month/Year in one of my columns and when I formatted as date it added day (Month/Day/Year as 1/1/2014). Is it possible to show date as just Month/Year? 

[tringuyenminh92 · Accepted solution]

Hi  @Anonymous,

you please try with Calculated Measure (not calculated column):

% Basic Margin Percentage = divive(sum(Basic Margin),sum(Revenue)) 

In case there is no Basic Margin column, you could add one more Calculated column to compute.

For second question, you could not show date as Month/Year, but you could show X-Axis as Month/Year by remove Day in Month Year hieararchy.