Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello everyone,
I have a matrix table like the one below, as you can see, the column have two levels, financial year and quarters.
I would like to put border around the year only so that the reader can easily identify financial year when they read the matrix.
any help would be great.
Solved! Go to Solution.
Hi @Nietzsche
You can be a bit sneaky and make the | only appear on the last Quarter. Then using conditional formatting to only format the cells with a | in them.
Measure would be something like this:
. =
IF (
SELECTEDVALUE ( Sales[SaleDate].[Quarter] ) --For the current quarter
= CALCULATE (
MAX ( Sales[SaleDate].[Quarter] ), --is it equal to the max quarter
ALLSELECTED ( Sales[SaleDate].[Quarter], Sales[SaleDate].[QuarterNo] )
),
"|", --if it is return |
BLANK () --Otherwise blank
)
Then conditionally format this column like this:
If the cell contains a | return a black background.
Make sure the measure is below your calculation in values.
For the very first column use the grid border
Hope this helps!
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Hi @Nietzsche
Will the matrix stay in this shape?
If so you could use a line rotated:
Insert -> Shapes _> Line -> Rotation 90
It isn't perfect but it is a workaround!
Ignore that, check out this genius move at 5:20:
How To Put Thick Borders On Matrix Visualizations In Power BI (youtube.com)
Use a measure that returns a | and format that!
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
hi Sam,
Thank you for the reply.
That pipe separate technique is cool but will not work for my situation because I have two column while in the video, he only had one column header.
If I add pipe separator on my visual's value box, pipe separator will end up at the end of every quarter. so it end up looking like this
Hi @Nietzsche
You can be a bit sneaky and make the | only appear on the last Quarter. Then using conditional formatting to only format the cells with a | in them.
Measure would be something like this:
. =
IF (
SELECTEDVALUE ( Sales[SaleDate].[Quarter] ) --For the current quarter
= CALCULATE (
MAX ( Sales[SaleDate].[Quarter] ), --is it equal to the max quarter
ALLSELECTED ( Sales[SaleDate].[Quarter], Sales[SaleDate].[QuarterNo] )
),
"|", --if it is return |
BLANK () --Otherwise blank
)
Then conditionally format this column like this:
If the cell contains a | return a black background.
Make sure the measure is below your calculation in values.
For the very first column use the grid border
Hope this helps!
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Hi @SamWiseOwl
Thank you very much, although there is a empty space after every quarter, this is actually pretty good workaround.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
38 | |
31 | |
26 |
User | Count |
---|---|
97 | |
87 | |
43 | |
40 | |
35 |