In Matrix table, Is it possible to freeze total at bottom when stepped layout is off

[simonchung]

In Matrix table, Is it possible to freeze total at bottom when stepped layout is off

[lmed]

If anyone else finds them here looking for a solution to this, pleaes give the idea a thumbs up so it will be considered to be implemented: https://ideas.powerbi.com/ideas/idea/?ideaid=d11acad6-f5a7-eb11-89ee-0003ff454c66

[Anonymous]

Hi @simonchung ,

What does "Freeze" mean?

I have built a data sample, in case you want to hide the sub-total at the buttom of Matrix, please try:

Measure = IF(ISINSCOPE('Table'[Category]),SUM('Table'[Value]),BLANK())

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[simonchung]

Thanks for your reply, 

Freeze means the Total would fixed at bottom, no matter how many the reords the total can be viewable 

[斥敌]

我认为这没有办法，我采用的方法是缩小矩阵的高度，在最下方用其他可视化组件显示汇总值

[amitchandak · Accepted solution]

@simonchung , No, I do not think I have seen an option for that. Please log an idea - https://ideas.powerbi.com/ideas/