Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
In Matrix table, Is it possible to freeze total at bottom when stepped layout is off
Solved! Go to Solution.
@simonchung , No, I do not think I have seen an option for that. Please log an idea - https://ideas.powerbi.com/ideas/
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
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.
Thanks for your reply,
Freeze means the Total would fixed at bottom, no matter how many the reords the total can be viewable
我认为这没有办法,我采用的方法是缩小矩阵的高度,在最下方用其他可视化组件显示汇总值
@simonchung , No, I do not think I have seen an option for that. Please log an idea - https://ideas.powerbi.com/ideas/
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
88 | |
85 | |
82 | |
65 | |
49 |
User | Count |
---|---|
138 | |
110 | |
104 | |
66 | |
64 |