Forum Discussion
Value - Restricted to Count
When attempting to create a simple bar graph, one of my values (Profit_LCY) is restricted to count. How can I I get the actual value to show?
2 Replies
Make sure your value is formatted as a number, rather than text or any of the other options.
Hi@ 0experienceinBI
In the Visualizations pane, right-click the filed, and select the aggregate type you need. If there are just two options :Count and Count(Distinct),
The formatted of this filed is not numeric ,otherwise you can change the aggregation in there.
Reference: https://docs.microsoft.com/en-us/power-bi/service-aggregates
Best Regards,
Lin
