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.
I have some formatting issues using PowerBI's matrix. I will show what I have achieved in PowerBI and the ideal formatting as below:
As shown, my ideal formatting is to have different background color for the first 5th "columns".
However in PowerBI, at most I can have one single united color for all the "column" (i.e. "Rows" in the matrix).
Are there any ways I can format like Excel in PowerBI using matrix? I will not switch using table because the required layout won't accept duplicated value shown on each row (i.e. repeating the same branch name for row 8 to 11 if you use the Excel's ideal format as an example).
Thanks.