The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
How can I hide the entire column totals row when there is only one row in the group and the totals are redundant?
I fixed the sort issues using the "Sort By Column" functionality. One down, 2 to go.
Here's the updated code:
@brookseitz I don't think that's really a thing but if you can provide sample data could maybe give it a shot.
It's absolutely a thing that I've done for a long time in other reporting tools. Actually there are several things I'm trying to figure out how to do that are fairly easy to do elsewhere.
1. Hide repetitive total rows (i.e. there's only one detail row in the group
2. Sort columns, groups and rows
3. Display absolute values (in accounting, some values are assumed to be negative)
I kinda figured out the sorting issues but haven't resolved how to hide the sort values/groupings.
Here's an example of where I am:
Here's were we're trying to get to and also would like to show absolute value for all numbers:
Thanks for your help,
Brook
@brookseitz Yeah, but can you save me having to type a bunch of fictious data and just post some sample data as text that can be used to recreate the scenario?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
141 | |
109 | |
108 | |
76 | |
63 |
User | Count |
---|---|
273 | |
129 | |
123 | |
101 | |
91 |