Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Showing text and Numeric Values in Matrix

Happy Friday! I am working on a report which shows vacation days for all employees. I have created a matrix visual and would like to have the text 'HOL' show up on days that are holidays (i.e. 12/25 and 1/01). We also would need the hours to appear on the days when an employee took leave and have the total hours for the week. 

 

I do have holidays in the dataset, however holiday dates are not assigned to each employee. Those dates are in the DATE DIM table.

 

Is there a way to write a DAX measure that would have TEXT for Holidays and NUMBERS that SUM for the vacation days? If a DAX measure would not work, maybe a measure to change the background color of the cell would be a better option? 

 

See picture below. Any help would be appreciated.

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    You can create a measure that eventually produces text all around.  Including for the numbers and the summation. They will need to be converted to text using FORMAT() for example.