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.
I am trying to create a matrix to display receipts as a percentage of total billings.
The rows are grouped by billing month.
The columns are grouped by receipt month.
I can successfully compute and render the desired value throughout the matrix, the percentage of receipts/billings for a given billing and receipt month combination.
(Sample at bottom)
Now, my question is how to display the sum of billings for a billing month on the left as a total? The client wants to be able to visually contextualize the percentages to a hard dollar total.
Thanks.
@agdoesfinance Seems like a case for custom matrix hierarchy:
Looks like you are probably right, Greg. I assumed it would be a bit of a coding chore, but I'm up for the challenge.
Thanks for the advice, and I will mark as a solution once I successfully implement the concepts.
@agdoesfinance You could also do it the old fashioned way where you put the measure or what not in the Columns and then manually shrink all of the multiple duplicate columns that generates but it usually looks bad and messy. There might be a custom visual that allows you to do it cleanly as well.
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 |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |