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.
I have a field parameter slicer to control what fields are shown in a column chart (Y-axis). The X-axis is my time dimension (Year -> Month -> Date). On Power BI desktop, everything works as expected. When I select different fields in my field parameter slicer, only the Y-axis changed. However, when I publish the report to Power BI service, when I select different fields in my field parameter slicer, the time/date dimension is expanded all the way down. It is set by month by default but when I click one of the fields in my slicer, it will expand all down one level in the hierarchy.
Solved! Go to Solution.
Hi,
I do have exactly the same problem and effects as described by @Anonymous . As soon as I change my multi-selection field parameter slicer in PBI Service my column charts are expanded all down one level in hierarchy on the x-axis. In PBI Desktop everything is fine but published in PBI Service it does not work properly. This only happens since a few days. I haven't had this problem the weeks before.
In addition, I have this problem on my column charts. On tables with the same hierarchies as the column charts (Quarter->Month) everything works fine - in PBI Desktop and Service.
Any ideas how to fix this?
Best regards, Chris
Hey Chris, I made an Issue post here. If you can, vote for it there and comment what you have said above. Thanks - Josh
Hi @Anonymous
Is it possible that on your visual you have clicked on the "Expand all down one level in hierarchy"
I am not. It would seem like I am but my field parameters are not close to my visual. It works completley fine on Desktop but malfunctions on Service.
Thanks,
Josh
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.