Forum Discussion
pmoore
9 years agoFrequent Visitor
Formatting in Power BI for summarized fields using Direct Query
Hello, I'm wondering if there is a way to use more precise formatting for values like Count when summarizing a field in a report. It seems like I have some control over formatting, like using co...
vanessafvg
9 years agoCommunity Champion
under your modelling table you should be able adust your formatting including decimal points or using a commma
pmoore
9 years agoFrequent Visitor
Correct, that's what I was referring to - I can format the underlying values (if it is a number) and that translates into sum, average, etc. However, if you do a count, the underlying formatting does not matter and I'm looking for a way to format those count values on the report.
- vanessafvg9 years agoCommunity Champion
pmoore How are you doing your count? Just dragging a text value into a visual and making it count it there?
the best way to handle that is to actually create a count measures i.e countrows(tablename) and then format the measure