Forum Discussion

Tarunika15's avatar
Tarunika15
New Member
1 year ago
Solved

How to keep y axis static

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 displ...
Need Help
Show and Tell
Tips and Tricks
  • dlopesc04's avatar
    dlopesc04
    1 year ago

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

  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

     

      

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.