Forum Discussion
Column goes missing from matrix when using sort order table
Hi Everyone, I'm quite stuck on something. My data has Year, Quarter, Category, Sub-category, and Value When added to a matrix, I have a custom column order for the years using a seperate YearOrde...
Try this:
I have dummy data in 2022 Actuals for testing purposes. When I select show items with no data, 2022 Actuals shows up but is indeed blank! When I replace 'Year' in the matrix with the one from the data table, 2022 Actuals column shows with the dummy data, so the mystery remains
with Year from YearOrder table
with Year from Data table
Hi,
Share the link from where i can download your PBI file.
