Forum Discussion

LMorman's avatar
LMorman
Icon for Helper I rankHelper I
9 years ago

Displaying items with no data

  I am trying to create a matrix to display a Sales Person portfolio of clients and who they have met with in person, when and who they have not. Table 1:  includes the name of the Sales Person and...
LMorman's avatar
LMorman
Icon for Helper I rankHelper I
9 years ago

what is the best way to share the data.  I am having issues with copy and paste from Excel into the relply box

dkay84_PowerBI's avatar
dkay84_PowerBI
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

When you filter, the data that doesn't have corresponding values for your filter/slicer will not be shown.  That is the point of a filter.  Maybe I am not understanding your question?

  • LMorman's avatar
    LMorman
    Icon for Helper I rankHelper I
    9 years ago

    I have a list of Companies assigned to a sales person and a list of activities the sales pro has completed with their assigned companies.  They track activity types such as face to face meetings, e-mails, phone calls etc. 

    I want to show the sales pros full list of clients regardless of whether or not they have had an activity and only show the face to face activities ( by activity date)