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.
Hello All,
I have 3 table like this,
and relation bwtween them like this,
I have made slicer out of "Region" table which has selectAll,
I need sum of all people in one graph (this is working), in second i need average of Sales % (currently its summing up).
How I can achive average sales ? Both charts need to controlled by same slicer.
Thanks!
Solved! Go to Solution.
HI @NithinBN,
>>In the sales graph (bottom left) I should get Average sales, now I am getting sum
You can right-click on the value fields that you used on chat to change the summarize mode from 'sum' to 'average'.
Work with aggregates (sum, average, and so on) in the Power BI service
Regards,
Xiaoxin Sheng
HI @NithinBN,
>>In the sales graph (bottom left) I should get Average sales, now I am getting sum
You can right-click on the value fields that you used on chat to change the summarize mode from 'sum' to 'average'.
Work with aggregates (sum, average, and so on) in the Power BI service
Regards,
Xiaoxin Sheng
@NithinBN Not sure I am following exactly. In the second graph over in the Visualizations pane, click the drop down arrow of the column in the Values area and change aggregation to Average instead of Sum?
@Greg_Deckler : In the sales graph (bottom left) I should get Average sales, now I am getting sum
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |