Forum Discussion
Power BI Gantt text conditional formatting
Hi everyone,
I have a custom visualization (Gantt 3.0.12.0) from Microsoft in my report. I would need to use conditional formatting for task's texts (when there is some subtask which is late (legend has Late and On time), the text of the task would change to different colour based on conditional formatting).
There is no "conditional formatting" option in the visualization's formatting options. Does anyone has any solution or ideas to get conditional formatting there?
If you need further information etc., please feel free to ask!
Thank you in advance,
-L
6 Replies
- Akash_Varuna
Super User
Hi Limee Could you try this workaround
Create a DAX measure or column to flag tasks ("Late" or "On Time").TaskStatus = IF(COUNTROWS(FILTER(YourTable, YourTable[Status] = "Late")) > 0, "Late", "On Time")Add this calculated field to your Gantt chart as a data point or legend field to visually distinguish tasks based on status.
If this post helped please do give a kudos and accept this as a solution
Thanks In AdvanceSorry, I didn't understand. I mean I have already Late and On Time in legend, but I am asking if there is any chance to get conditional formatting for task name (Task / Parent in Gantt)
Do anyone have any alternative solutions? I really need to do it. Please feel free to ask if you need some further information. 🙂
LHi Limee
Thank you for reaching out microsoft fabric community forum.Unfortunately, the Gantt 3.0.12.0 visual doesn’t support conditional formatting for the Task Name (Task/Parent) field (like changing text color). That said, here are a few workarounds you can try:
-
Add visual cues to task names using a calculated column:
FormattedTaskName =
IF([Status] = "Late", "⚠️ " & [TaskName], [TaskName])
Use this in the Task field to help flag late tasks.
-
Use tooltips to show detailed task status info on hover.
-
Try a different Gantt visual from AppSource — some third-party visuals offer better formatting options, including conditional text formatting.
If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community
Thank you.
-
Hi Limee
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi Limee
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
