98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Power BI training and help » Using dates as row headings - power BI summing data
Using dates as row headings - power BI summing data
Resolved · High Priority · Version 365
Thu 3 Feb 2022, 09:38Delegate Kerri said...
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
Thu 3 Feb 2022, 10:18Trainer Jens said...
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
Thu 10 Feb 2022: Automatically marked as resolved.
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Power BI tip:Implement Row-Level Security (RLS)If your reports contain sensitive information, implement Row-Level Security to control access to data at the row level. RLS allows you to define rules that restrict data access based on user roles, ensuring that each user sees only the relevant data according to their permissions. |
