Reply
rpinxt
Solution Sage
Solution Sage
Partially syndicated - Outbound

Place a blank column in the layout

So I have this visiual :

rpinxt_0-1654605276059.png

What I want to achieve is a blank row where these yellow lines are.

That way it is nicer to compare the same months of differen years.

Because I also would want to turn this visual in a graph and have blank column between the bars.

 

I saw online Bas of "how to power BI" do this with calculation items in Tabular editor.

But I cannot reproduce it.

Probably because I am trying to do this with dates? He did it with measures.

 

Is there a way I can accomplish this with dates/periods?

3 REPLIES 3
rpinxt
Solution Sage
Solution Sage

Syndicated - Outbound

And to add to this @NickolajJessen when I put the blank column in the measures, this is what happens:

rpinxt_0-1654607750673.png

 

I want both Januaries (and other months) of 2021 and 2022 together.

Putting the blank in the measures adds also a blank between 2021 and 2022 jan and I do not want that.

NickolajJessen
Solution Sage
Solution Sage

Syndicated - Outbound

1. Create measure that returns BLANK()
2. Add to matrix

3. Rename on the visual to just be "-" (you can't rename it to be all blank sadly)
4. Optionally add color to the column to separate

NickolajJessen_0-1654606464264.png


Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 😊

 



Syndicated - Outbound

Thanks but I cannot add the measure to the columns of the matrix...

 

avatar user

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)