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.
Hello All,
While building the pivot table in excel spreadsheet from Analyze in Excel, the filter options do not show the correct filtered values after another filter has been applied even though the data is being filtered correctly.
Consider the following report:
Name Department
ABC Sales
DEF Finance
PQR Sales
XYZ Finance
If I filter on Department 'Sales', the report is filtered correctly:
Name Department
ABC Sales
PQR Sales
However the filter options for 'Name' still gives me:
ABC
DEF
PQR
XYZ
Filters in Power BI desktop and service are fine. This only seems to be happen in using Analyze in excel.
Has anyone come across this issue before or anything I am doing wrong?
Thanks!
Solved! Go to Solution.
Hi Lydia,
Seems like this was a standard behaviour of the pivot.
Thanks for your help anyway!
Thanks!
@apollo89,
I am unable to reproduce this issue on my side. Could you please post a screenshot about how you create the visual and add filters in Excel?
Regards,
Lydia
Hi Lydia,
Seems like this was a standard behaviour of the pivot.
Thanks for your help anyway!
Thanks!
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.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |