Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Add custom row to Table/matrix visual based on slicer

Hi,  I've a requirement from users to add a row at the end of Matrix visual for 'Other/Misc' if the slicer is selected as you see in the box.   'Other/Misc' data is also available in separate table...
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

you can use summarize and union to do that. But I not sure how to get total before Misc.

 

 

Balance Sheet = union(SUMMARIZE(Sales,Sales[Brand],"Col1",sum(Sales[Sales]),"Col2",sum(Sales[COGS]),"sort",COUNTROWS(Sales)),SUMMARIZE(Sales,Sales[Brand],"Col1",sum(Sales[Sales]),"Col2",sum(Sales[COGS]),"sort",COUNTROWS(Sales)),DATATABLE("Area",STRING,"Col1",DOUBLE,"Value",DOUBLE,"Clo2",DOUBLE
,{
{"    ",0.0,0.0,10000}
}
) )

Datatable is to add some statics data

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

 

 

 

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Please check Edit Interaction under Format Tab, I found Interaction has been stopped. It should be like give below.

    https://www.dropbox.com/s/8yafsuybvvsp2bb/Retail_PBIRS.pbix?dl=0

     

    Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
    Thanks.