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 All,
In the bar chart, I add 2 fields to be Value because of both of them need to be showed as bar, one of the column A value is summed, and another column B value no need sum, but after to drag to the bar chart Vaule, the column B is also be Sum, and there is no choice like "Don't Summarize" as in a table, as the attached image. Do you know any solution for this case? Thanks.
Winnie
Solved! Go to Solution.
@Anonymous , Anything you do not want to summarize should either be part of the axis or the legend.
Hi @Anonymous ,
In power bi desktop, I’m afraid you cannot put a field without a sigma value or measure in the Value field when using chart visuals like bar chart, line chart, area chart.. The ‘Don’t summarize’ option I have seen is in the table visual. As @ amitchandak said, anything you do not want to summarize should either be part of the axis or the legend. So the picture you have posted may not in the stacked bar chart visual and you cannot put a sigma value into Value field if you want to sum it.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
In power bi desktop, I’m afraid you cannot put a field without a sigma value or measure in the Value field when using chart visuals like bar chart, line chart, area chart.. The ‘Don’t summarize’ option I have seen is in the table visual. As @ amitchandak said, anything you do not want to summarize should either be part of the axis or the legend. So the picture you have posted may not in the stacked bar chart visual and you cannot put a sigma value into Value field if you want to sum it.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , Anything you do not want to summarize should either be part of the axis or the legend.
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 |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |