Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 )
Solved! Go to Solution.
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.
Proud to be a Super User!
Paul on Linkedin.
They should remain hidden unless the user drags the column to reveal it
Proud to be a Super User!
Paul on Linkedin.
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.
Proud to be a Super User!
Paul on Linkedin.
@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
Proud to be a Super User!
Paul on Linkedin.
@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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
87 | |
82 | |
65 | |
63 | |
57 |
User | Count |
---|---|
171 | |
113 | |
110 | |
73 | |
73 |