Showing results for 
Search instead for 
Did you mean: 
JohnBI Frequent Visitor
Frequent Visitor

ANALYZE IN EXCEL's Pivot Table Number Format "missing"

Using Pivot Table @ ANALYZE IN EXCEL, the "Number Format" @ "Field Settings":

Working as usual @ VALUESS area
"Missing" @ both ROWS area and COLUMNS area





















Also, the formats of certain fields (like Date) do not seem to follow PBI model's format after connecting to ANALYZE IN EXCEL.


For example, my Date is formatted as "Date" in PBI model, but it seems to be in "text" format here. Without the ability to change the format at Pivot Table (described above), DATE column at Row Field cannot be used for "Timeline Slicer".


Please kindly advise on the issue. Many Thanks !!



Vicky_Song Established Member
Established Member

Re: ANALYZE IN EXCEL's Pivot Table Number Format "missing"

@JohnBI, I personally think what you get is correct that we can only change number format for metrics in the PivotTable. For your issue, you can put your date column to the Filters then you can filter the data based on date. 

Helpful resources

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 26 members 946 guests
Please welcome our newest community members: