Forum Discussion
Table Conditional Formatting based on Values
I'm looking for a way to format the background colors based on a break of Fake Invoice #'s. I just need the first row colored, like the example below. I don't knnow if this is even possible.
You can try the following steps:
1. Add an index column to a table in the Power Query.
If the index column is not added, the effect in the table visualization is shown below.
2. Create several measures as follow:
Measure = VAR _t = ADDCOLUMNS('Table', "Group", RANKX(ALL('Table'), [Fake Invoice #], [Fake Invoice #], ASC, Dense)) RETURN SUMX(_t,[Group])formatting = IF(ISODD([Measure]), "yellow", "green")3. Make the Conditional Formatting settings as shown here.
Is this the result you expect?
Best Regards,
Community Support Team _YuliaxIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
You can try the following steps:
1. Add an index column to a table in the Power Query.
If the index column is not added, the effect in the table visualization is shown below.
2. Create several measures as follow:
Measure = VAR _t = ADDCOLUMNS('Table', "Group", RANKX(ALL('Table'), [Fake Invoice #], [Fake Invoice #], ASC, Dense)) RETURN SUMX(_t,[Group])formatting = IF(ISODD([Measure]), "yellow", "green")3. Make the Conditional Formatting settings as shown here.
Is this the result you expect?
Best Regards,
Community Support Team _YuliaxIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Excellent solution! Thank you.
