Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
been struggling over this one for a while and cannot find a solution.
i have a matrix displaing financial information (Profit and Loss)
The Matrix is split by headers in the rows, Months across the columns
Example below
My issue is that the Total row at the bottom of the table displays the final net profit as a negative of the true Net profit
i alter the values within each row header to reflect a report view of the figures instead of the values need for the calculation.
this has lead to some confusion as users read the total line instead of the net profit line and draw the wrong conclusions. unfortunatly i cant fix people
is there away to remove this total line, in my other tables i simply set grand totals to white text on white back ground to remove the line
however in this table i cannot do this as i still need the grand total in the right hand colunm to display the year total.
Any thoughts?
Proud to be a Super User!
Solved! Go to Solution.
Hi @AnthonyTilley ,
What about this?
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @AnthonyTilley ,
Have you tried this?
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Unfortunatly i cannot remove subtotals as these are still needed for the idividual levels within the table when the table is expanded to the second level.
Proud to be a Super User!
Hi @AnthonyTilley ,
What about this?
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |