Kerri has attended:
Excel Intermediate course
Excel Advanced course
Excel Dashboards for Business Intelligence course
Power BI Reporting course
Power BI Modelling, Visualisation and Publishing course
Using dates as row headings - power BI summing data
Hi,
I am trying to use a table with dates as the row headings (Jan-21, Feb-21 etc.) with account names in the column headings. However, when I try and create a graph with (example ) staff costs for Jan 2021, the graph is summing all the data under jan - so not just staff costs, but all costs. How do I stop the graph summing all data in Jan-21?
Thanks
RE: Using dates as row headings - power BI summing data
Hi Kerri,
Thank you for the forum question.
In the Filters pane you can filter the graph to only display the Staff costs.
Select the graph and you should be able in the Filters pane to see the columns you have added to he graph. If you hover over the column header in the Filters pane, you get a down arrow to the right of the column header. Click the down arrow and you can now untick the accounts you don't want to summarise on the graph.
I hope this makes sense
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
