Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi All,
I am a new BI developer, and I currently developing a report with a requirement to calculate the number of orders packed in the last hour and show this measure in a stacked column chart by packers.
I used the DAX code below
Orders Packed last hour =
var _AnHourAgo =
MAX(Fact_PPDOrderTransitionLog[PackedOnDate]) - TIME(1,0,0)
var _LastHour =
FILTER(Fact_PPDOrderTransitionLog, Fact_PPDOrderTransitionLog[PackedOnDate] >= _AnHourAgo)
var _LastHourSum =
SUMX(_LastHour, [Number Of Orders Packed])
return
_LastHourSum
The results are accurate when placed in a card visual. However, when used in stacked column chart I get unexpected results as can be seen.
Please can anyone help with a solution on how to fix this issue as this will really help me out.
pictures of the data set is shown below
The important columns are the PackedOnDate, and updatedbydesignation (as packers) , I also have a date table if that helps.
Thanks, any help is very welcome
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
26 | |
24 | |
12 | |
11 | |
10 |