Calcular linea de tendencia solo de los meses que tienen datos

[Nicolas01]

Hola Buenas 

Estoy armando mi dashboard y necesito graficar una linea de tendecia que se muestre solo en los meses que tienen datos distintos de cero, he probado algunas formas pero no logro hacer que funcione. Alguien me puede ayudar?

[v-yilong-msft · Accepted solution]

Hi @Nicolas01 ,

I create a dashboard and a table as you mentioned.

Then I use Line chart and create a new calculation.

Calculation = IF([Sum of Total]=0,BLANK(),[Sum of Total])

Finally you will get what you want.

Best Regards

Yilong Zhou

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

[Nicolas01]

thanks you for your answer. i'll try and will comment you if works the solution.

[v-yilong-msft]

Hi @Nicolas01  ,

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

Best Regards

Yilong Zhou

[Nicolas01]

Finally, the solution can be obtained by applying a filter to the data from the "is not" option and indicating "0". Then I filtered the data that did have value and automatically adjusted the trend line.