Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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:
Proud to be a Super User!
@DataInsights 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.
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.
Proud to be a Super User!
@DataInsights This is the measure that I need to apply conditional formatting to:
The measure you provided doesn't need to be changed. Simply create the measure I provided (using the specific column in your matrix rows) and use that new measure in the conditional formatting of your main measure.
Proud to be a Super User!
@DataInsights Morning, unfortunatelly I cant use dax you provided since it only works with calculated columns:
Where I am using measure and not a column as value:
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |