Visualization issue

[bdeleur]

Hi,

I'm having a visualization issue that I can't quite figure out. Hopefully, someone can help me further. I have a line chart showing the hourly average (measurements taken every quarter-hour). This is represented by the white line. It's an occupancy line, indicating how much occupancy there is. Sometimes, there may be a notification that there is no more capacity. In that case, a red block appears. This is also a line with just a marker, placed on the secondary axis. The value is 1 while the line could be 15. Now, I would like to have this marker on the white line instead of always at the same height on the secondary axis. How could the formula be in DAX for this?

[bdeleur · Accepted solution]

I thought too complicated. I made an if statement: if the score is 1, then the value of the other measure, otherwise blank. Sometimes you shouldn't think so hard. Thanks for brainstorming with me

[Uzi2019]

Hi @bdeleur 
You can align both the Lines by having Mimimum and Maximum range fixed for Y axis and secondary y axis.

I hope This may resolved your issue!

[bdeleur]

Hi @Uzi2019 ,

Hi, that won't work because both are different numbers. One is 1 and the other is 15. You can't combine them that way.