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 by only Year, with SaleType as UNK, and Make also UNK 

I created SalesAgg table with combination of Fact table and 'Other/Misc' data using UNION and Summerize.

and from SaleType and Make slicers I've filtered this UNK (Unknown default) as users doesnt want to see.

So now how do I add Ohter/Misc row to the matrix when its checked by ignoring UNK filter in both 'SaleType' and 'Make' tables.

 

I create separate/Disconnected table just for Slicer with one column and one row.

Need Help
Show and Tell

3 Replies

  • amitchandak's avatar
    amitchandak
    Super 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.