Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

View all the Fabric Data Days sessions on demand. View schedule

Reply
rpinxt
Solution Sage
Solution Sage

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

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

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! 😊

 



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

 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors