Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi there, I have a matrix that is displaying a different value in one cell when the groupon the row is expanded.
The Matrix has the fees earned by department each day of the month. When expanding the row it displays the braekdown of the fees for the Consultants within that department.
Here I have highlighed the cell and you can see the correct value on the card in the top right.
Expanding the row then changes the value
This report is published to web. When I view the same report in Desktop or within the Workspace the values are correct in both states. This is Desktop and not expanded.
The data is coming from an SQL database view of individual calendar events with the Consultant, date and value. There are no relationships setup for this view in PowerBI and the filters on the Card and Matrix are exactly the same.
Columns: Start Date (DateTime)
Rows: Region, AssignedTo (Strings)
Values: Sum or Value
Any help or pointers would be greatly appreciated.
That's pretty weird. Maybe the wrong value is a cached value from an earlier point in time? Does refreshing the page or resetting it to default change it at all?
User | Count |
---|---|
21 | |
20 | |
12 | |
10 | |
8 |
User | Count |
---|---|
30 | |
28 | |
14 | |
13 | |
11 |