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 ,

Thank you for clarifying your requirement. If you want to display only 4 to 5 spaced-out values on your secondary Y-axis while using month names (without a full date hierarchy), one approach is to create a simplified supporting table that contains only the specific months you wish to display.

You can then relate or filter your main data based on this new table to limit the visible data points. In terms of DAX, you may create a measure that dynamically filters the months, for example by using a TOPN function or by creating a slicer-based selection to control which months are displayed. Additionally, you can adjust the axis settings in Power BI by turning off continuous axis and using categorical axis instead, which will give you more control over how many and which labels appear on your secondary Y-axis. This combination of data modeling and visual formatting should help you achieve the cleaner, limited display you're aiming for.

Passionate about leveraging data analytics to drive strategic decision-making and foster business growth.

Connect with me on LinkedIn: Rohit Kumar.

[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]

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.