Forum Discussion
Formatting Calculation Group Items / Rows in P&L
Hi!
I am trying to create a P&L based on a Calculation Group, but want to format specific rows (Gross Profit etc) differently from the detail rows.
In the example below I would like format "Gross Profit 1", "Gross Profit 2" and "EBIT" with Bold text, and also take away the possibility to drill down on GP1 etc... Is this possible?
For info:
- All detail rows are measures based on account groups
- All summary rows are measures based on detail row measures (eg GP1 = [net revenue]+[direct COGS]
Thanks!
Hi, Oggie
In the current version, Power BI does not support directly setting the font bold effect for specific rows in the matrix, if you want to achieve highlighting, you can change the background color display based on a value in the row.
Related links:
Solved: highlight specific rows in matrix - Microsoft Fabric Community
How to Highlight Specific Rows and Cells in Power BI (popautomation.com)
It is not allowed to disable drill down for specific rows, you can create a separate table visual object for summary rows and another table visual object for undetailed rows. In this way, you can disable drill-down for the entire summary table.Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
1 Reply
Hi, Oggie
In the current version, Power BI does not support directly setting the font bold effect for specific rows in the matrix, if you want to achieve highlighting, you can change the background color display based on a value in the row.
Related links:
Solved: highlight specific rows in matrix - Microsoft Fabric Community
How to Highlight Specific Rows and Cells in Power BI (popautomation.com)
It is not allowed to disable drill down for specific rows, you can create a separate table visual object for summary rows and another table visual object for undetailed rows. In this way, you can disable drill-down for the entire summary table.Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum