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.

Frequent Visitor

Is it possible to manually add a row via power query for a non-manually created table?



I have a table in my PowerBI report that that I want to manually add a row via power query. The table is queried from a SQL server DB, I don't want to directly insert a record in the SQL server DB table in this case, and I was wondering if it is possible to manually add a row in PowerBI table without touching the upstream SQL server DB table?


The reason behind this is because, I have a cluster column chart for "Mean time to recover" that is calculated from outage table- when there is no outage lets say for April, there will be no data presented in the chart for April, stakeholders are asking a zero value for the month that if is no outage. I don't think it is possible to do it from the visualisation side, so I was thinking to manually add an outage record, and the period of time is 0, so that it shows a zero value for the month.

Please refer to the following column chart, as you can see, there is no value for Apr 2023, Jan 2023 in the last 6 calendar months because there was no outage at all for these months. Is there a way to manually add a blank record in the table with outage time=0? Or are there any other better ways to hack it?


Current graph:



What I want to achieve (I manually created it in excel):





Thank you for any tips or suggestions.

Super User
Super User

Hi @Hyuna_8000 ,


Add a 'plus zero' to the end of your measure, like this:

Mean Time to Recover =
) + 0



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!

Helpful resources

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