Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |