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 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

 

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.

     

      

2 Replies

  • dlopesc04's avatar
    dlopesc04
    Resolver II
    1 year ago

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

  • 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.