Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
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.
thanks you for your answer. i'll try and will comment you if works the solution.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |