New to power BI

[Anonymous]

Hello all -- I need to create a chart to show headcount per month, I have all the data - start dates and ends dates just need a guide on how to show in power bi.  New to the system so need initial steps to get this going!  Anything would be appreciated.  

[v-alq-msft]

Hi, @Anonymous 

You may refer to the following official tutorial to Get started with the Power BI service. 

Tutorial : Get started with the Power BI service 

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Anonymous ,

Stacked bar Chart or Stacked column chart is the answer. 

Use this YouTube VIDEO to understand everything about the charts.

Regards,

Gaurav Raj Singh 

https://www.linkedin.com/in/gauravrajsingh/

If I answer your question, please mark my post as solution, this will also help others.

[nhoward]

Hi @Anonymous ,

you can use the search in the top right corner, to look for Active Employees per month, or Head Count and you'll get a few different ideas to work through. 

Like this one: https://community.powerbi.com/t5/Desktop/Count-total-active-employees-in-each-month/m-p/808254/highlight/true#M388654

It is designed to work with a data model that has a master calendar, and a date slicer being active on the page. 

Active Employee Count =
VAR CurrentDate = MAX ( 'Date'[Date] )
RETURN
    SUMX (
        data_employees,
        IF (
            data_employees[Start Date] <= CurrentDate
                && OR ( data_employees[End Date] >= CurrentDate , ISBLANK(data_employees[End Date]) ),
            1,
            BLANK ()
        )
    )

[Anonymous]

Thank you - I'm very new to power BI and the tutorials i'm finding online do not match the options i see on my power bi screen. I'm using the webversion, figured out how to upload my file and that's it!  Do you know of any services that can give live tutorials?

[amitchandak]

You an option to see edit in web mode. explore that

[nhoward]

HI @Anonymous ,

Power BI Service (the web version) is mostly a publishing tool, not a building tool.  You need to use Power BI Desktop to build the report, as it is the only tool that lets you create measures.  The online training will be about Power BI desktop mostly.  

This is the microsoft training pages. open it using Chrome to get the full benefit. https://docs.microsoft.com/en-au/power-bi/