Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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 _Yuliax
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 _Yuliax
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Excellent solution! Thank you.