Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |