cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
sebbyp
Helper III
Helper III

change chart series to secondary axis

Is it possible to move a time series to a secondary Y axis as in excel?

3 REPLIES 3
v-micsh-msft
Microsoft
Microsoft

Hi sebbyp,

Currently I don’t think this is possible.

Secondary Y Axis currently is only available under combo chart, when put time values, combo chart would automatically change it into count values.

By the way, could you please share more information regarding the reason for putting time series into secondary Y Axis? Maybe we could offer some additional workaround.

Regards

 

My data set contains values which are measured in different units for example percentage, in millions, in billions, whole number.  But the values all fall within one column for the entire data set with a separate column describing the unit.  In order to compare the different time series to see if there is a relationship i would normally (in excel) send a time series to a secondary Y axis.

 

I have tried the combo charts but i have learnt that these only allow comparison of columns on a specific time series.

Is there any more news on this.  Really missing this functionality and is something that has been available in Excel for a very long time. 

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors