March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
User | Count |
---|---|
121 | |
97 | |
95 | |
83 | |
49 |
User | Count |
---|---|
198 | |
162 | |
92 | |
79 | |
67 |