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.
Hi all, I have been asked to move the matrix's total column onto the right hand side of the matrix. I have tried to do this on my own, but cannot find the correct measure. I am counting the number of analyst per day, and that is giving me the number of reports within their queue. It looks like this : (I have hidden the names)
The # of reports is the count of analyst names. I can't figure out how to put the total on the left side, as I am working with a count and not a sum. Is there anything I can do to achieve this? Thank you all.
Solved! Go to Solution.
Hi @abeirne ,
I have create a simple sample, please have a try.
Then create a calculated table.
column_total =
VAR _summarize =
SUMMARIZE ( Table2, [Name], "Date", " Total", "Value", SUM ( Table2[Value] ) )
RETURN
UNION ( Table2, _summarize )
Currently, there is no way to change the column subtotals to left. Please click the Idea link below and vote for this function.
Idea Link: https://ideas.powerbi.com/ideas/idea/?ideaid=fa4c855b-67ce-4970-b4ee-72226772ba79
Hi @abeirne ,
I have create a simple sample, please have a try.
Then create a calculated table.
column_total =
VAR _summarize =
SUMMARIZE ( Table2, [Name], "Date", " Total", "Value", SUM ( Table2[Value] ) )
RETURN
UNION ( Table2, _summarize )
Currently, there is no way to change the column subtotals to left. Please click the Idea link below and vote for this function.
Idea Link: https://ideas.powerbi.com/ideas/idea/?ideaid=fa4c855b-67ce-4970-b4ee-72226772ba79
Hey,
If you have e.g. table: Date, Analyst Name and # reports = count( Data[Analyst Name])
Then you can create calculated table
Analyst Total = Summarize ( Data, Data[Analyst Name], "Total", [# Reports])
Create Relationship based on Analyst Name between two tables
Then add these table columns into matrix Rows, and use Data (original table) columns Date in columns & measure [# Reports] in values
Then turn off row sub totals
and turn off in row headers Stepped Layout
Result
Let me know if that solves your problem
HI @abeirne
Check this link:
https://community.powerbi.com/t5/Desktop/Matrix-with-left-hand-totals/m-p/1238695
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |