Forum Discussion

mrothschild's avatar
mrothschild
Icon for Continued Contributor rankContinued Contributor
5 years ago

Matrix - measure or column for text?

PBIX file is here: https://drive.google.com/open?id=1Q4tEueE8QP3iJBgORrBX4o6ebXegpSG3

 

I have a matrix with different manufacturers as columns, different dates of events as rows, and event descriptions as values.  When fully collapsed, I want the headers for each columns and date that have "sub"-data to be visible, but the matrix values themselves should be blank (because it will be showing rows by years rather than actual dates).  When slicing by date, if a specific manufacturer didn't have an event on that date, I'd like that column header to hide.  When slicing by manufacturer, if nothing occurred on a specific date, I'd like that row header to disappear.  I've tried several measures and just using the column itself for values, but can't get to an algorithm that leads to desired outcome.  Screenshots of three different matricies trying to accomplish this below:

 

 

SELECT ALL

 

DATE SELECTED

 

 

MANUFACTURER SELECTED

 

EVENT TYPE SELECTED

 

 

 

 

 

 

 

 

 

 

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    Please check if you really want others to see this data ( create a separate pbix with sample/dummy data)

    Please check your data model - there are lots of disconnected tables and inefficient relationships (for example the calendar and period tables should be combined

    Please consider using the filter pane instead of on-page slicer filters.