Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Anonymous
Not applicable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Conditional Formatting
08-16-2023
01:30 AM
Hello,
I have a report where I am trying to compare the number of forecasted days for a project vs all the hours entered for each project.
I've used a measure and I am trying to conditionally format the meausre so it shows green if the hours are less than the forecasted days and red if it is more.
Can someone advise how to do this as I can't get it to work.
Image attached for reference
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-16-2023
02:00 AM
@Anonymous
- Create a measure for calculating the difference
- Navigate to visual properties ( Cell element)
- Select the column which you want to format
- Turn on Background color
- Then fill the below window. The Red marked field should be your newly created measure.
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
02-09-2025 02:16 AM | |||
12-13-2024 12:02 PM | |||
10-23-2024 09:02 AM | |||
10-30-2024 02:44 AM | |||
09-10-2024 05:36 PM |