Hi team,
Is there a way to perform conditional formatting for a row value based on both a measure and dimension?
For example, from the image, its color coding to red if the value is less than 70%, however I want another condition to be added: color code it to red only if value is less than 70% and ‘Planned’ , do not color code it to red if actual.
Hi @balawatt
Pivot tables in Quick Sight allow for conditional formatting, enabling you to apply formatting to the value section based on any dimension or measure using aggregation
Please refer the below Quick Sight conditional formatting blog this might be helpful for you.
Hi Xclipse,
I looked at it, but i want specific conditional formatting only for some fields, not sure if you looked at my request right. Thanks
Hi @balawatt
You’ve applied conditional formatting in the Pivot Table to the Actual dimension column, which also affects the Planned dimension. If you want to apply conditional formatting separately to the Actual dimension, you’ll need to create calculated measure fields like “Actual {Measure Field Name}” and use a table visualization. This will allow you to select the calculated fields individually and apply dedicated conditional formatting to each.
Example: Actual {Measure Field Name}
ifelse(dimension = "Actual", {Measure Field Name}, 0)
You can create similar measures for other dimensions.
Hope this helps!