Forum Discussion
Formatting text value within table
Hello dear super users
Could I please get some advice for formatting the text values in the table please .
I have created a staff leave report and each letter repressent different leave type, how can i format the letters with different colors ? In the table I have the staff names and the date (only 1-31) as it has a slicer filter out each month.
below is the value area where the letters needs to format with different colors. I have used CONCATENATEX to convert the numbers to the letter as a measure.
Many thanks
Remove two of the closing brackets I think.
Assign the same formatting to each column unfortunately. So pick the column and choose the same measure field. A little tedious.
9 Replies
I think I understand what you're wanting to acheive. Check out this and see if you can relate it to what you're trying to do.
https://www.youtube.com/watch?v=SO4mk1H94OA&ab_channel=EnterpriseDNA
Can you share the measure you are using that you referred to?
I may be able to help more with a little more detail.