Forum Discussion
Post ProdigySeparate font color Conditional formattings
Hi, I am creating font conditional formatting for one of my value in the table.
The only problem is that you cant create multiple rules for font formating for same value.
I would like to know is there some way how I could create two Font color conditional formattings, one for value only and other for totals only.
If even possible for grand totals as well.
Thanks.
6 Replies
- DataInsights
Super User
Try this solution.
1. Create the measure below using the dimension field in your visual. HASONEVALUE determines if the row is a total.
Conditional Formatting = IF ( HASONEVALUE ( Table1[Code] ), "#298B46", "#A8337D" )2. In the conditional formatting screen, select the measure above. Apply to values and totals.
Result:
Justas4478DataInsights I unfortunatelly can't use this since my source of data is a measure and not a column.
Is it possible to make it work for a measure?
As well I will ask since I forgot.
Can the conditional formating be made to apply colors to specified data range?
For example if it is not total and value is >=0 and 3< do [color hex], >2 and 6< do [color hex].
And then similar for total values.
As well I dont know if it makes any difference but my data is using live connection model so I am locked for using only measures.- DataInsights
This should work with a live connection since it's a measure. The column in HASONEVALUE is the field in your matrix rows. Yes, you can specify data ranges in the measure to apply colors accordingly. If you provide your measure I can take a look.
