Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
When I create Matrix or Table visualization columns that use COUNT display with really long column headers which dramatically changes the width of the column. Example if column name is: Date the column label is "Count of Date" which is a huge waste of real estate. Any solutions?
Create explicit named measures rather than using the default implicit measures created when you drag a field onto a visualization's Value(s) area.
The functions that replace the various defaults are SUM(), AVERAGE(), MIN(), MAX(), DISTINCTCOUNT(), COUNT(), STDEV.S() / STDEV.P(), VAR.S() / VAR.P(), and MEDIAN().
All of these take a single field as argument.
E.g.
NamedCount = COUNT( FactTable[FactField] )
User | Count |
---|---|
98 | |
76 | |
75 | |
49 | |
27 |