The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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] )