Miguel Myers on 08 Oct 2024 05:00:00
Enabling customized calculations at the query level for subtotals and grand totals would offer greater flexibility in reporting and preserve performance. Efficient organization of control settings to modify the style of these totals separately will empower report creators to achieve their desired appearance, while addressing their need for more control and customization in reporting.
- Comments (482)
- Merged Idea (2)
RE: Epic idea: Custom totals for tabular visuals
I don't understand why this is a difficult feature to add. You already have an option to apply formatting to labels on subtotals. Why not just add an option to apply conditional formatting to subtotals too? Right now i'm showing negative numbers in red but the subtotals that are also negative are showing in black. Totally misleading and takes away from the visual purpose of the report.
RE: Epic idea: Custom totals for tabular visuals
This is the most critical feature we need in Power BI. This is available in all the reporting tools.
RE: Epic idea: Custom totals for tabular visuals
absurdity!
RE: Epic idea: Custom totals for tabular visuals
Workaround:
DimTableWithAll = UNION(ADDCOLUMNS(DimTable,"New",DimTable[Original]),ADDCOLUMNS(DimLocations,"New","Total"))
Join to DimTable via PK/SK and turn on Bidirectional Crossfiltering bingo! You just can't bold your total row unfortunately. Conditional formatting has a way to go on Power BI. Also can we please rotate the column headers!
RE: Epic idea: Custom totals for tabular visuals
It is inconsistent to have conditional formatting on the data rows but not on the totals rows and is likely to cause confusion. I would like to highlight negative values including in the overall total row.
RE: Epic idea: Custom totals for tabular visuals
Why doesn't the subtotal just inherit the formatting from the values? Seems to be the simplest solution
RE: Epic idea: Custom totals for tabular visuals
We need this, quite useless without...
RE: Epic idea: Custom totals for tabular visuals
Hi All i have done with some tricks to apply conditional formatting to total values.
http://sahayasathish.blogspot.sg/2018/05/poer-bi-conditional-formatting-on.html
let me know if its usefull
RE: Epic idea: Custom totals for tabular visuals
Agree with everyone, we can't have conditional formatting that doesn't apply to subtotals, it destroys the drill down capability of the matrix. Shouldn't really have to vote on this
RE: Epic idea: Custom totals for tabular visuals
Any update on getting conditional formatting for table and matrix total rows?