Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
192 | |
79 | |
70 | |
50 | |
42 |