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.
Within power BI desktop, i am not able to hide few columns subtotals. I can either hide all or show all for subtotals. Is it possible to hide subtotals for few columns and show on others with a matrix?
Wondering if there a way to only hide the Avg Days total in the matrix table, circled, below?
Anyone solve this? I have a calculation that makes sense at the line item level but makes no sense summed up. Is there a way to hide the Total and Subtotals for this?
Hi,
You can create a new measure to do this. Inside it you will check if value is equal or higher than minimum with simple if.
That's how I have done this.
Measure= IF(SUM('Table'[some_value])>=(MIN('Table'[some_value])+1);BLANK();SUM('Table'[some_value]))
Instead of +1 you can use smaller value if needed. Depends from your data.
Below standard column first and measure in second column
Other option is to play with ALLEXCEPT but this might be harder in regards to slicers
Hope it will help someone.
Hi,
On the same lines I was able to hide subtotal for a numeric and date column.
Numeric Column: Created a measure:
Yes, This would definitely work for hiding unnecessary totals/subtotals like dates, names, etc. on matrix columns. However if your Matrix rows contain Groups/Hirearchies then you will come up with all the line item in your table appearing in each group:
For example I created the following measure to hide account numbers in subtotals and Total:
I just found the solution:
I used the following measure for Account number:
I have the same issue. I don't think the March 17 Preview addresses the ability to selectively hide some subtotal columns.
Is there anything new that might address this?
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 |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |