Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 !!
John
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.