Hello Peers,
I have a query on getting average of percentages for categories.
In below images, I have a table where I have percentage evaluation for days and grades. In total at the bottom I get avg of those percentages. When I plot these in a column chart, I get the plot as shown in one of the images.
What I want to know that how to get an avg of these percentages as line in this column chart.
I have an example done in Excel. I want to achieve same result in PBI. Can some one please help me.
1 ACCEPTED SOLUTION
Hi @abhi-kharde ,
I created some data:
Here are the steps you can follow：
1. Create measure.
Measure =
AVERAGEX(
FILTER(ALL('Table'),
'Table'[GRAD]=MAX('Table'[GRAD])),[Value])2. Use Leng and Clustered column chart.
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @abhi-kharde ,
I created some data:
Here are the steps you can follow：
1. Create measure.
Measure =
AVERAGEX(
FILTER(ALL('Table'),
'Table'[GRAD]=MAX('Table'[GRAD])),[Value])2. Use Leng and Clustered column chart.
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
