Forum Discussion
Custom Matrix Table Total Column
Hi Everyone, I am having difficulty trying to figure out this one. Thanks in advance 🙂
Scenario: I have two measures in a matrix table [1] Gross Profit, [2] Gross Profit %.
Problem: How can I show the [2] Gross Profit % measure ONLY in the total column?
Current:
Desired result:
Gross Profit
Gross Profit = CALCULATE( IF( [P&L] = 0, BLANK(), COALESCE([P&L],0)))Gross Profit %
Gross Profit % = DIVIDE( [Total Gross Profit (Journals)], [Total Sales (Journals)], 0 )
You can hide the columns by dragging the right column boundary to the left. You will need to turn off word wrap in the formatting options though.
They should remain hidden unless the user drags the column to reveal it
6 Replies
ronaldbalza2023 I created The New Hotness for this problem: The New Hotness (Custom Matrix Hierarchy) - Microsoft Power BI Community
Hi Greg_Deckler, thanks for taking the time on this. That's a lot of work I'd say for a simple problem (kinda) :D. Appreciated it!
You can hide the columns by dragging the right column boundary to the left. You will need to turn off word wrap in the formatting options though.
PaulDBrown figure this one out already until you mentioned turning off the word wrap which I think is genius! However, are there any instances that it will show up or it will just hide and it will just show up when you actually unhide it? Thanks alot!
They should remain hidden unless the user drags the column to reveal it
