Solved: Entering a extra row in matrix visualization

Anonymous · ‎11-14-2018

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?

Anonymous · ‎11-14-2018

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

View solution in original post

v-jiascu-msft · ‎11-23-2018

Hi @Anonymous,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-jiascu-msft · ‎11-15-2018

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎11-14-2018

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