cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
rpinxt
Post Prodigy
Post Prodigy

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
Post Prodigy
Post Prodigy

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

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

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors