Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hi Team,
I need to build a Table visulal like below with Sub Totals.
But I am not able to add the sub Totals in Table Visual.
The Matryx Visual shows the heirarchy View like below
Is there a way i can build a chart with subtotals on . I want every row to be shown separately instead of heirarchy.
Regards,
Rolin
Solved! Go to Solution.
Hello @Anonymous you can achieve it in one way,
>> Select the matrix visual>>Go to visual format>>Go to Row Headers>>Under Options>> Turn off stepped layout.
output may look something like this as per the example that I have considered.
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
Hello @Anonymous you can achieve it in one way,
>> Select the matrix visual>>Go to visual format>>Go to Row Headers>>Under Options>> Turn off stepped layout.
output may look something like this as per the example that I have considered.
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
Thanks alot @Kishore_KVN . Its exactly what i wanted. But the problem is I am using parameters to dynamically change my rows. something like below
Everytime i select a different option from attribute 1 ,2 ,3 dropdown the heirarchy colapses.
Is there a way i can have the heirarchy always expanded.
Regards,
Rolin
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.