I noticed a possible bug with the table or matrix visuals. I have a matrix that shows revenue by department for a selected month as well as YTD values thru the selected month. It appears that if the selected month has no values, then the YTD values don't show up in the table/matrix either. This should not happen. I tested in a tradition pivot table in excel and it works as expected. The value for the selected month is blank, but the YTD value is still displayed. Any solutions for this behavior?
Thanks!
Collin
3 Comments
v-haibl-msftMicrosoft Employee
Could you please provide a sample data table and your measures to me? I’d like to repro it locally to see if it is related to measure formula.
Best Regards,
Herbert
Vicky_SongImpactful Individual
Status changed:NewtoNeeds Info
cproloffAdvocate I
Good Morning,
We can mark this issue as resolved. Not sure what happened, but when I logged in this morning the matrix was working as I would expect.
Thanks!
Collin