Entering a extra row in matrix visualization

[Anonymous]

hi,

Can i add a dummy row in matrix visualization?

I am able to show the data which is there in source but if i want to add extra row then will i  be able to add?

Any solution for this?

[v-jiascu-msft]

Hi @Anonymous,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

[v-jiascu-msft]

Hi @Anonymous,

Please also download a demo from the last reply of How-to-add-a-fixed-percentage-assessment-fee-to-a-sub-total. It's also a wonderful demo.

Best Regards,
Dale

[Anonymous · Accepted solution]

Hi @Anonymous,

Yupp, This is possible.

Go in Modeling tab then select New Table then follow this dax.

TableWithDummyRow =
VAR PrevTable = CALCULATETABLE('DataSet')
VAR DummyRow = DATATABLE("Id",INTEGER,"Date",DATETIME,"Name",STRING,"Value",INTEGER,
{
{100,"01/01/2018","Z",1000}
})

Return UNION(DummyRow,PrevTable)

I am also attaching pbix file for your reference.

Here you Go:  

https://drive.google.com/file/d/1BeCCodGPsmVNSsRMe1l1LOfK7uL5QJSx/view?usp=sharing