Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Entering a extra row in matrix visualization

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?
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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