Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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.
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |