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

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.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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