How to use DAX to not count data for graph

[JGH1]

Hello,

I'm having difficulty creating a simply dual y axis graph because my data is being counted. 

I've read through several posts and I now understand that one can use DAX to correct this, but I don't know how to do so.

Can someone please help me?

Cheers,

JH

https://drive.google.com/drive/folders/1BnYoLwRs6p74JxczmaHf_cMm77nW0h0v?usp=sharing

[Anonymous · Accepted solution]

Hi @JGH1 ,

Do you mean to create a line chart with double y? My steps are as follows:

If I misunderstood what you mean, please point it out.

You can refer to the following documents that may be helpful to you:

Create A Native Line Chart With Dual Y Axis In Power BI (c-sharpcorner.com)

Dual Y-Axis Line Chart - (powerbi.tips)

Dual Axis Chart in Microsoft Power BI - Step By Step - TechnicalJockey

Best Regards,

Neeko Tang

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