Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
Context:
I have a table with timeshifts of people working with an hourly gross rate associated with it. In it's original form, the timeshift entries only contain daily timestamps indicating:
What I want to achieve is a graph that shows labour costs per hour within a 24h day. Something like this:
Since I don't have a row per hour in my data set, I followed THIS tutorial to create an "hourly timestamp" to be able to visualise that graph.
Everything looked fine because I got this result:
As you can see, this employee has an hourly gross rate of 30,26 which in Power Query always shows 30,26 (which is correct).
Now, when I add this to a graph/table, that hourly gross rate starts to go crazy. Instead of getting 30,26 per Hourly Timestamp of a shift date, that number grows the further we go down. So on Mar 10, the hourly gross rate is okay, but the day after it doubles for every single row.
I have my Shift date connected to my main date table. I also tried disconnecting it to see if that's the problem, but it isn't. I am really puzzled why does Power Query show one set of numbers and on the dashboard I get something else. I know that I "artificially" generated those timestamps so is that perhaps the problem?
Could someone let me know what the issue is or how to do this without generating those artificial Hourly timestamps? Many thanks!
Solved! Go to Solution.
Found the issue. Once I added the source file name (since these are multiple CSVs appended from blob storage) I was able to identify that the issue was in the CSV exports.
Found the issue. Once I added the source file name (since these are multiple CSVs appended from blob storage) I was able to identify that the issue was in the CSV exports.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
126 | |
113 | |
73 | |
65 | |
46 |