Forum Discussion
Data Manipulation - HELP!
Hi, I am very much stuck on how to produce a visual from a report I have - please help!
I am trying to create a visual (labelled 'B') from the dataset (labelled 'A').
In the visual labeled 'B', 'Revenue' would be the sum of all revenue within that commercial term (T&M = SUM(A3:A7), FP = SUM(A8:A10) and CR = SUM(A11:A14)). This is the same sum for Cost also.
For 'Work Order Number', I need to find the number of distinct values per Commercial Term and represent them as seen in visual 'B'. The colours are there as a visual aid to show where each distinct value has been counted.
The latter part of the query is where I am having most difficulty as I can't seem to find a way to make all of the changes and represent them in a single visual so if anyone could crack the code that would be most helpful!
P.S. If none of this makes sense I apologise in advance!
Hi deanbland ,
I created a sample pbix file (see attachment) for you base on your data, please check whether that is what you want.
Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.
3 Replies
deanbland , Create measures
Revenue = Sum(Table[Period Revenue])
Cost= Sum(Table[Period Cost])
Work order Number = distinctcount(Table[Work order Number])
In matrix visual use show on row and put the commercial term on the column
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
Hi, thank you for your reply!
I have followed as suggested, but now it is just adding everynumber up as seen below.
The numbers in visula B should represent 1 of the numbers in the columns, not all of them added together (shown below)
Hi deanbland ,
I created a sample pbix file (see attachment) for you base on your data, please check whether that is what you want.
Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.
