Continuous x-axis with aggregated value

Question

Hi brilliant Power BI community!&nbsp;&nbsp;I am currently testing out moving from QlikView to Power BI, but have run into an issue with one of our graphs.&nbsp;&nbsp;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&nbsp; &nbsp; |&nbsp; &nbsp; Work Hours&nbsp; &nbsp; |&nbsp; &nbsp;Year1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;24&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20132&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20181&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 47&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2017&nbsp;And so forth.&nbsp;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.&nbsp;&nbsp;When I do this in Power BI by creating a grouped by table, the graph just seems to load for a long time.&nbsp;&nbsp;Thank you for any help you can give me!&nbsp;&nbsp;Let me know if you need extra information, then I can create some dummy data.

greg_deckler · Answer

Anonymous - 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?
&nbsp;
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

anonymous · Answer

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.

Forum Discussion

Continuous x-axis with aggregated value

2 Replies

Related content

Continuous x-axis issue

Show all Dates on continuous X axis

dynamic x-axis based on filter

Scatterplot with Categorical Date x axis NO AGGREGATION

X Axis Year Order (Continuous vs Categorical)