Visualize only 5 values on secondary y-axis by using just month names

[RGummels]

I am trying to visualize only 5 to 6 values/numbers on my secondary y-axis, but without a correct date hierarchy it does not work. 

Can anyone give me some effective dax formulas or measurements to use please?

[v-hashadapu]

Hello @RGummels , Just getting back to see if the shared details answered your question. If so, marking it as "Accept as Solution" would be greatly appreciated to guide others in the community. Feel free to reach out with any additional questions!

[rohit1991]

Hi @RGummels

• In Power BI, a secondary Y-axis is only available on Combo charts (Line & clustered/stacked column). Plain line or column charts don’t support a second axis.
• To use it: switch to Line and clustered column, put bars in Column y-axis and your line in Line y-axis, then turn on Secondary y-axis in the Format pane and assign the line to Secondary.
• Using month names? Sort the Month Name field by Month Number so the order is Jan…Dec.
  
  Reference: 
  https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart?tabs=powerbi-d... 

[v-hashadapu]

Hi @RGummels , 

As haven’t heard back from you in a long while, we’re closing this thread per our follow-up policy. For any further discussions or questions, please start a new post in the Microsoft Fabric Community Forum — we’ll be happy to assist.

Thank you for being part of the Microsoft Fabric Community.

[RGummels]

I am so very sorry.... was too hectic and I didn't receive all of your messages on time. My sincere apologies.

so in my chart, you see all of the values on the red lines, but I only need to display 4 to 5 values a little spreaded out.. Is that possible?

[v-hashadapu · Accepted solution]

Hi @RGummels , Thank you for reaching out to the Microsoft Community Forum.

Please refer attached .pbix file for reference and share your thoughts.

If this helped solve the issue, please consider marking it “Accept as Solution” and giving a ‘Kudos’ so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.

[v-hashadapu]

Hi @RGummels , it's been a while since we last heard from you. We are ready to assist you with resolving the issue, but we need the necessary details from you. Kindly share the information required so we can better understand and address your issue.

[v-hashadapu]

Hi @RGummels , Thank you for reaching out to the Microsoft Community Forum.

Can you please share more details regarding your query. Detailed summary with sample data to work on would be really helpful. Thank you.

[rajulshah]

@RGummels ,

Can you show a sample picture of what the actual vs required scenario? Thanks.