Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there,
I am currently working on a productivity dashboard. I have received durations from workers, on how long certain tasks are taking. What i now want to do is, have all of these durations as a bar chart, i succeeded in that. But I would also like to have a line that shows the norm of the workers. I have a table for this, with multiple norms for certain tasks. But i only need one value from this colomn. So how can i select only one value from this colomn, to show this as a norm in my graph?
Solved! Go to Solution.
Hi, @Blurbuh
Based on your description, I created the following sample data:
I have the following chart:
I use the following DAX expression to select 450 in the norm column
standard line = CALCULATE(MAX('Table'[norms]),FILTER(ALL('Table'),'Table'[norms]=450))
Put it in the chart as follows:
You can choose the minimum, maximum, or average value in this column. All you need to do is change the DAX expression above to:
standard lineMAX = CALCULATE(MAX('Table'[norms]),ALL('Table'))
I've provided the PBIX file used this time below.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Blurbuh
Based on your description, I created the following sample data:
I have the following chart:
I use the following DAX expression to select 450 in the norm column
standard line = CALCULATE(MAX('Table'[norms]),FILTER(ALL('Table'),'Table'[norms]=450))
Put it in the chart as follows:
You can choose the minimum, maximum, or average value in this column. All you need to do is change the DAX expression above to:
standard lineMAX = CALCULATE(MAX('Table'[norms]),ALL('Table'))
I've provided the PBIX file used this time below.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |