March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi, I'm fairly new to PowerBI. I have data which shows one row for each product per week. On PowerBI most of the products show one line on the table, but a few have split across 2 lines. It has put the "last week" data on one line and "this week" on another.
LW = Last week, TW = This week
WOW = Week on Week and is calculated, which is why it shows on both rows.
I've checked and there are no other fields which are different in the 2 weeks which would cause the split
Thanks for any help
Solved! Go to Solution.
Thanks I watched your video, it didn't specifically help with this issue. I did find the issue was with one of the week on week calculations. When I removed that everything reverted back to being on one line per product
Thanks I watched your video, it didn't specifically help with this issue. I did find the issue was with one of the week on week calculations. When I removed that everything reverted back to being on one line per product
@littlejt , there is some other group by in the table, or the product has a sort by column (used for changing sort order) and now it has multiple values for that
Sort by column-https://youtu.be/KK1zu4MBb-c
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
129 | |
90 | |
75 | |
58 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |