cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Akshatha29 Frequent Visitor
Frequent Visitor

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
ravik4934 Member
Member

Re: Entering a extra row in matrix visualization

Hi @Akshatha29,

 

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

3 REPLIES 3
Highlighted
ravik4934 Member
Member

Re: Entering a extra row in matrix visualization

Hi @Akshatha29,

 

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

Community Support Team
Community Support Team

Re: Entering a extra row in matrix visualization

Hi @Akshatha29,

 

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.
Community Support Team
Community Support Team

Re: Entering a extra row in matrix visualization

Hi @Akshatha29,

 

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.