Tabular format with Subtotals

[venkatasuresh_g]

Hi,

 We have a user request to design a page in report to show the data in table format with Weekly subtotals and Monthly subtotals in same table as shown below , I am not sure if we have a visual in PowerBi that can do this , user want this table for YTD period 

Thanks

Suresh 

[v-shex-msft]

HI @venkatasuresh_g,

Currently power bi seems not suitable for your requirement.

Perhaps you can try to change the table records to add these subtotals, then you can use if statement checks current row context and replace the display contents.

Using the SELECTEDVALUE function in DAX - SQLBI

Regards,

Xiaoxin Sheng

[amitchandak]

@venkatasuresh_g , You can rename sub total's label but that is not available as of now at per row level. So I think you can only rename once for all level