Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello All,
I need your help because I feel like I am doing something wrong with Logic of Measurement. What I am trying to do is; I have raw data table in PBI, like the table at left hand side. And with DAX; I am calculating the Weekly Results. As of here, there is no problem.
But I cannot get any chart like below at right hand side.
As far as I search and learn that; a Measure cannot be used in a X-Axis of a Chart. I feel that, I couldn't understand the logic of Measurement.
Can you please tell me; with which Visual I should visualize the weekly scores in a Chart?
Solved! Go to Solution.
Hi @Anonymous ,
A measure cannot be used in a X-Axis of a Chart. It is right. However, as your image shown, it is using a week column as x-axis in the chart. You can implement it. Please reference my sample to have a try.
Measure =
VAR ON_TIME = CALCULATE(SUM('Table'[Quantity]),FILTER('Table','Table'[Status] = "On time"))
VAR Quantity_week = CALCULATE(SUM('Table'[Quantity]),ALLEXCEPT('Table','Table'[Week]))
RETURN
DIVIDE(ON_TIME,Quantity_week)
For more details, please see the attachment.
Hi @Anonymous ,
A measure cannot be used in a X-Axis of a Chart. It is right. However, as your image shown, it is using a week column as x-axis in the chart. You can implement it. Please reference my sample to have a try.
Measure =
VAR ON_TIME = CALCULATE(SUM('Table'[Quantity]),FILTER('Table','Table'[Status] = "On time"))
VAR Quantity_week = CALCULATE(SUM('Table'[Quantity]),ALLEXCEPT('Table','Table'[Week]))
RETURN
DIVIDE(ON_TIME,Quantity_week)
For more details, please see the attachment.
@Anonymous , This chart is possible. Measures can be dragged to the value field. You simply Drag these two on Bar/Clustered chart you will get that
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |