Forum Discussion
Sort in Bar Chart
All working now !
Sorry I'd put cost rather than costs in the formula.
Really appreciate your help..............cheers
Hi steveorme69,
I assume that both your table are related by account. You have to do the following measures:
Cost = CALCULATE(SUM('SAGE Trans'[Value]); Nominal[Reference] = "Cost")
Income = CALCULATE(SUM('SAGE Trans'[Value]); Nominal[Reference] = "Income")
This will give you the expected result and you can then place them in the bar chart by the order you need.
But if you want further details please share your steps.
It's not a video it's a gif image I taken it with ScreenToGif and it's really simple to use just select the area press record and save the image, then upload it as a photo in your post.
Regards,
MFelix
Hi, thanks
Still getting the following error
https://1drv.ms/f/s!An_LprApKikkbLUKLGWVylqWcMI
Thanks
Steve
This is regional setting related change the dot-comma ";" by comma "," everything should work correctly.
Regards,
MFelix
Great that worked but it now groups Income and costs together as follows:
https://1drv.ms/u/s!An_LprApKikkfYoQqSGVtpbvn68
Thanks
Steve
All working now !
Sorry I'd put cost rather than costs in the formula.
Really appreciate your help..............cheers