cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AbhishekH
Advocate II
Advocate II

Recent change in X-axis behaviour to continuous axis for categorical chart

Hi,
I have just obsereved on the power bi report service that I am no longer be able to show continous x axis if I am using a legend field.

AbhishekH_0-1663151255677.png


This used to work before (until last week) , here is the example:

AbhishekH_1-1663151495196.png

above I am using continuous x - axis while using categories

 

Please look into this ?

 

Cheers,

Abs

 

9 REPLIES 9
bfb99
New Member

This issue still has not been fixed. Very frustrating. Replying to bump thread. 

Genscape
New Member

Having the exact same problem and it's beyond annoying.

ama209
Frequent Visitor

A temporary fix I have come across is to publish the report into PBI Service, Select 'Edit' when viewing the report (within service, located at the top of the screen), and turn off date heirarchy.

 

I recognize that this may not be beneficial for everyone, but for those who don't require the heirarchy and simply need a single view of their line chart, this is a short-term fix till Microsoft gets things going on their end.

v-yueyunzh-msft
Community Support
Community Support

Hi, @AbhishekH 

According to your description, when you put a field in "Legend", the X-axis is not showing continuous values.

First for "Legend", its main function is to group and evaluate the values displayed on your Y axis, and then display them in our visual object.

When our Legend has different discrete values for each X-axis, then it will be displayed in dots.

vyueyunzhmsft_0-1663222942316.png

 

Consecutive values are only displayed when our Legend has the same grouping for the X axis.

vyueyunzhmsft_1-1663222942321.png

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Hello @v-yueyunzh-msft  ,

Thanks for looking into this. @QF  Thanks for raising this, properly.

@v-yueyunzh-msft  if you look at the scenario provide by @QF this is the bug, I am encountring since this week.

Hope this gets resolved soon.

Cheers,

Abhishek

Try a test case, where you have a legend that groups data by category for example. Then have data plotted against a date on a line graph visual. This will work fine in powerbi desktop, but will break when published, switching the x-axis from continuous on date to categorical on date.

 

This is certainly a bug that was introduced over the weekend, and Microsoft needs to realise this, there have been countless other posts on the forum on this topic. Please look to fix. How are people supposed to trust the software when what they create changes on publish? The more time Microsoft denies this is a bug, the deeper the bug will get and it will be harder to fix. Please look into this!

 

Cheers,

QF

Hi, @QF 

According to my test, I selected "continuous" on the X-axis in Power BI Desktop, but after publishing to Power BI Service, it still displays "continuous" in the Editing view. 

vyueyunzhmsft_0-1663231552927.png

vyueyunzhmsft_1-1663231563010.png

 

 

If my understanding is inconsistent with your question, you can provide us with corresponding screenshots so that we can help you better.

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Hi Aniya,

Here I will be using the "Retail Analysis Sample" PBIX file.

After downloading the file, opening it, creating a new page, I make a Line Chart view with:

X Axis: Store -> "OpenDate" as a date hierarchy,

Y-Axis: Sales -> "Average Unit Price"

Legend: Item -> "Category"

I then drill down, "expand all", to the lowest level of data. This is what it looks like in desktop:

QF_0-1663232638491.png

Notice the X-Axis is continuous:

QF_1-1663232702737.png

 

Then I publish the report. This is what it looks like in the service:

QF_3-1663232763353.png

Notice the X-Axis is now categorical, and broken. There is no way to change it back in the service.

 

This is a bug, please look to resolve. I will look to make a separete post about this also.

 

Cheers,

QF

 

 

 

 

I am able to replicate the same issue @QF is experiencing in Power BI Desktop after installing the September 2022 release.  It seems to be a (hopefully) unintended side effect of the recent change to hierarchical x-axis behavior.

As others have stated, the issue appears to occur when using a Line visual with a built-in Date hierarchy on the x-axis, and only when a legend is applied.

 

Using the same visual setup as the above example, also from Retail Analysis Sample:

  • X-axis is Continuous by default when set to OpenDate (non-hierarchical)

jareynolds_0-1663277449312.png

 

  • When the x-axis is changed to use the built-in date hierarchy for OpenDate, the hierarchy is now fully expanded by default, but the x-axis is now Categorical and the Continuous x-axis is no longer available. 
  • Prior to the September update, the default behavior was a Continuous x-axis when the built-in date hierarchy was fully expanded, but it is now Categorical and cannot be changed.

jareynolds_1-1663277578702.png

 

Helpful resources

Announcements
collabdays lisbon

CollabDays Lisbon - 26 November 2022

Sessions include practical, hands-on experience that will help you take the next step in your career and know-how.

Difinity Conference

Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors