98.8% 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 » Line graph - how to remove all calculations | Forum
Line graph - how to remove all calculations | Forum
Resolved · Medium Priority · Version 365
Thu 17 Apr 2025, 11:16Delegate Yasmin said...
Yasmin has attended:
Power BI Reporting course
Line graph - how to remove all calculations
Good morning,
I want to create a line graph that plots the number of job postings per month on PowerBI. I add the date hierarchy to the x-axis as usual. But then I add the number of job postings to the y axis, and it creates a 'sum'. How can I make sure that it uses the actual number of postings, without converting the figure to a 'sum' or 'count of'?
Thank you
Thu 24 Apr 2025, 11:16Trainer Martin said...
RE: Line graph - how to remove all calculations
Hi Yasmin,
Thank you for your question to the forum.
It looks like the reason why your job postings end up being calculated is because of its data type. I would check this by selecting the appropriate header in the data view and change it from number to text in the formatting section on the ribbon. This action will stop the line chart displaying a sum
Kind regards
Martin Sutherland
(IT Trainer)
|
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:Create Interactive DashboardsBuild interactive dashboards by leveraging features like slicers, drill-through, and bookmarks. Slicers allow users to filter data dynamically, while drill-through enables detailed exploration of specific data points. Bookmarks help you save the current view, making it easy to switch between different states of your report. |
