Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ZC1
New Member

Sept 2022 Update Issue - Hierarchical axis

Since the Sept 2022 update I have issues with the X-axis of my line charts.  Chart 1 shows what the chart looked like before the update.  The chart is showing the results of testing conducted at multiple dates across the past year.  It uses a legend which is the Test Summary.  The data used in the chart is structured per the example in Table 1 (dummy data). 

 

Since the Sept 2022 update, the chart instead looks like Chart 2 both in Power BI Desktop and the Service.  I've tried turning on/off the "concatenate labels" option for the X-axis, adjusting drill down levels, etc. (see Charts 2 to 4) and I cannot recreate Chart 1.  The chart appears as desired until I add the "Test Summary" field to the legend.

 

Is there any way I can recreate Chart 1 post Sept 2022 update?  Is this a bug I can report somehow?  Any help greatly appreciated, thank you!

 

Table 1 - Data Structure Example

Data Structure.png

 

Chart 1 - Prior to Sept 2022 Update:

Before Sept 2022 Update.png

 

Chart 2 - After Sept 2022 update (default behaviour - concatenate labels on)

After Sept 2022 Update.png

 

Chart 3 - After Sept 2022 update (concatenate labels off)

After Sept 2022 Update - Concat Labels Off.png

 

Chart 4 - After Sept 2022 update (concatenate labels off, Month drill level)

After Sept 2022 Update - Concat Labels Off - Month Drill Level.png

1 ACCEPTED SOLUTION
HoangHugo
Solution Specialist
Solution Specialist

Oh, mabe in new version, the option does not exist. Try turn of "Auto to Date/Time" in Setting.

Capture 12.PNG

View solution in original post

4 REPLIES 4
HoangHugo
Solution Specialist
Solution Specialist

Hi

Try to select "Continous" in Type of X axis

capture 11.PNG

Thanks for the reply.  Unfortunately once I add in the "Test Summary" column into the Legend, the X-axis formatting options change from Continuous/Categorical to the below options:

 

X-axis formatting options with legend.png

HoangHugo
Solution Specialist
Solution Specialist

Oh, mabe in new version, the option does not exist. Try turn of "Auto to Date/Time" in Setting.

Capture 12.PNG

Yes!  Turning off "Auto date/time" seems to have worked.  Thank you very much 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.