Forum Discussion
Continued ContributorMatrix - data in data table not displayed when sliced
I have a pretty simple text-based matrix that has Asset Manufacturers, Model Types, and Serial Numbers as the Column hierarchy and Calendar Year, Month, Date as the Row hierarchy, and a simple measure to display Description as the Values.
When "Select All" across my slicers is chosen, the output display is as expected. When I start to slice, the row displays for dates start to get a little screwy, and I'm not sure why.
Here are some screenshots, where you'll note that in the data table, there are data associated with Airbus for Event Dates in 1975, but they are not being displayed with the matrix sliced as such.
Thanks!
I think using the Column of Event Description rather than a Measure is what I wanted.
5 Replies
- DataZoe
Microsoft Employee
mrothschild Do you have any values in the matrix table? Sometimes I find they do not behave as expected if they have no values or measures. Something simple even, like countrows or distinctcount of ID's in your table.
mrothschildDataZoe the Measure used to populate the Values section of the Matrix table is a simple:
SELECTEDVALUE([text description column])
- DataZoe
mrothschild I was looking at the documenation SELECTEDVALUE function - DAX | Microsoft Docs and because those have the same description that may be why it's not showing. Maybe try SELECTEDVALUE(distinct([text description column])), or include a column that will force each single row to show in the matrix.
