Forum Discussion
Post PartisanHow to create Matrix Headers?
Hi ERing
Aside from what ERing mentioned, you can create a headers table using DAX or M (via the enter data option). The key point is that a physical column is required to assign the output of a measure. Field parameters are suitable if your goal is to choose which columns to display, but they are not compatible with hierarchical structures. Please see the attached pbix.Hi again ERing ,
Good point! Columns with all blanks are hidden by default.
I would recommend selecting "Show items with no data" on the Column fields only (assuming that is where the measures are placed).
This will ensure that all measure columns are always displayed regardless, without introducing unwanted nonblank measure values.
Does this work for you?
Post Partisandanextian OwenAuger
I've run into an unexpected issue after implementing the solution.
Measures that result in "0" are not being popluated in my matrix. This occurs when the Matrix is filtered to only show limited CHANNEL_NAME where there may not be values for each column (Actual, PY, Budget, % vs PY, % vs Budget)
Each category (Spend, Revenue, Calls, Conversions) should have a column for Actual, PY, Budget, % vs PY, % vs Budget).
You can see in the screen capture that the "Spend" category is missing Actual.
The "Revenue" category is missing Actual, PY, % vs PY.
The "Calls" category is missing Actual, PY, % vs PY.
The "Budget" and "% vs Budget" are showing becuase I've set those measures = " ".
Is there anything I can do to correct this to show each column shows even if there is no value?
- OwenAuger
Super User
Hi again ERing ,
Good point! Columns with all blanks are hidden by default.
I would recommend selecting "Show items with no data" on the Column fields only (assuming that is where the measures are placed).
This will ensure that all measure columns are always displayed regardless, without introducing unwanted nonblank measure values.
Does this work for you?
- ERing
Wonderful! I'm glad it was an easy fix.