How to keep y axis static

[Tarunika15]

Hi all

I building a visual but i want to keep the y axis static  irrespectic of filter selection 

 i will be having multiple filters not only one but still the y axis should display all the values i.e all the 5 weeks (y-axis should be static) please let me know how can i achieve this 

Thank you 

Tarunika

[dlopesc04 · Accepted solution]

Try adding a + 0 to your measure.
i.e. -> Count of IncidentID = COUNT('YourTable'[IncidentID]) + 0

[Anonymous · Accepted solution]

Hi @Tarunika15 ， hello dlopesc04, thank you for your prompt reply!

Agree with Tarunika15's opinion, you could also use the COALESCE function to return zero when no data is available:

Incident Count = COALESCE(COUNT(IncidentTable[IncidentID]),0)

Result for your reference:

Best regards,

Joyce

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

[dlopesc04 · Accepted solution]

Try adding a + 0 to your measure.
i.e. -> Count of IncidentID = COUNT('YourTable'[IncidentID]) + 0