Forum Discussion
0experienceinBI
8 years agoNew Member
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?
v-lili6-msft
Community Support
8 years agoHi@ 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