Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there,
I have recently come across a bug that seems to be across all our Power BI reports and affects multiple chart types (Line & Stacked Column, 100% Stacked Column, and Stacked Area 100% confirmed).
Taking one report as an example: I have a Custom Date table, marked as a date table within my model. In my report canvas I have a slicer based on a Year-Quarter-Month date hierarchy, and the aforementioned chart types using the date field on the x-axis, with continuous as the type, expanded to month level.
When unfiltered, the x-axis labels appear as expected:
When filtering for year, everything is still as expected:
However, it gets weird at Quarterly and Monthly levels, BUT, only when January or Q1 is selected. Any other quarter or month shows as expected:
-Incorrect labelling on Q1 or Jan:
-Correct Labelling for other Quarters/Months:
If the issue was consistent, then I would accept the problem being my data model, but given the inconsistency, it must be on the MS side. Please may you investigate?
FYI, I am based in the UK region. Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @BITomS
The date in 100% Stacked Column is a primitive column or a calculated column ? If you select a month, normally the corresponding month is displayed on the X-axis. Can you provide your sample with a pbix file (remove sensitive info) ? Also what version of Desktop are you using?
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Community Support Team _ Ailsa Tao