Continuous x-axis with aggregated value

[NinjaEngineer]

Hi brilliant Power BI community! 

I am currently testing out moving from QlikView to Power BI, but have run into an issue with one of our graphs. 

I have information on how many work hours have been logged on different functional locations per year. I want to create a graph showing the distribution of the number of functional locations per amount of work hours per functional location per year. I.e. my data is structured as:

Functional Location    |    Work Hours    |   Year

1                                         24                      2013

2                                        50                        2018

1                                        47                       2017

And so forth.

The issue is creating the x-axis. Before, it has been created by making an aggregated array with average amount of work hours a year per functional location, using it as the dimension, and then counting the distinct number of functional locations as the value. 

When I do this in Power BI by creating a grouped by table, the graph just seems to load for a long time. 

Thank you for any help you can give me! 

Let me know if you need extra information, then I can create some dummy data.

[Greg_Deckler]

@NinjaEngineer - Yes, additional information and more sample data would be great. Also, if you could provide an example of your expected output that would be very helpful as well. Maybe a screen shot of the current visual?

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[NinjaEngineer]

Well i can't show you the actual graph, but I have created a dummy one:

In QlikView, the x-axis dimension is calculated as:

Aggr( Work_Hours/Year, Functional_Location)

While the value expression is then:

Count(DISTINCT Functional_Location)

The expression is aggregated and shown as a percentage (availble functions within QlikView graphs). I can't seem to locate where to attach a file, but the dummy data I was going to send was a table of functional location 1-10 with a random number between 0-100 and a random year between 2010-2019. Each functional location then had three entries in the sheet with random values each time.