Using a measure in Line y-axis won't work

[Sedos101]

Hi Everyone

Having issues using a measure in the line y-axis for a cluster for a Line and Clustered Column Chart,

the column y-axis is a measure that is using a slicer value when selected to show the resultant outcome.

The second measure i want to display in the y-axis line is using the same slicer value when selected to calculate something else.

However when I drag it in, it says "Can't Display Visualisation".

Can someone please help?

Thanks

[v-henryk-mstf · Accepted solution]

Hi @Sedos101 ,

Is it possible to provide the relevant test files or the created measure formula? In my test, putting the measure into the line and cluster column chart shows different results according to the slicer properly.

M = CALCULATE(SUM('Table (2)'[value]),'Table (2)'[ID]=SELECTEDVALUE(T1[ID]))

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

[Sedos101]

Hi 

I got it working but now I cannot get the line to be appearing correctly?

I am trying to display the legend for the line y- axis as the same as the column legend.

However my line only has two points and not one for each Hauler name as seen in the table below the chart...

Any help would be greatly apprecaited

Thanks 

[amitchandak]

@Sedos101 , is it showing some see details or more details, if so click and share details