cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alihijazi
Helper I
Helper I

creating charts

Hello I'm new to Power BI
I want to create charts for example:
a pivot table which displays the amount by category for the selected year and month as well as the YTD amount and the amount for the selected month but for last year and the YTD amount of the last year

Please advise

1 REPLY 1
greggyb
Resident Rockstar
Resident Rockstar

The forums are an area for discussion about specific features, problems, or concepts in Power BI.

 

The only appropriate response to such a broad question is a suggestion to google for "Power BI tutorial" to learn more about the products and how to do things. Additionally, it might be useful to peruse the documentation for the items which can directly address your questions.

 

Edit: Perhaps you might find the Microsoft-developed Power BI edX course helpful.

In general, you'll have to use Power Query to get data.

 

You mentioned YTD and prior year measures. The DAX functions which will support this are TOTALYTD() and CALCULATE() combined with SAMEPERIODLASTYEAR(). These all require a date dimension. Google for "Power Pivot date dimension" to understand the purpose, requirements, and usefulness of a date dimension.

 

If you run into specific problems in this process, feel free to start a new thread about that topic to get more focused help. As it stands though, the answer to your question *is* the product documentation and several already published tutorials.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors