Forum Discussion
Solved
How to create a visual object with a dynamic information
Hi all I need to create a card with a text that will change based on the result of the calculation of the median of the time to restore. Let me give an example The graphic shows the m...
Hi all:
With the help of a team mate we found the solution and it was a very simple one (I feel very stupid by the way).
Estados = IF(MEDIAN('Incs Cerrados (dic 2022)'[Tiempo Resolución])<=24, "Diario", IF(MEDIAN('Incs Cerrados (dic 2022)'[Tiempo Resolución])<=168, "Semanal", IF(MEDIAN('Incs Cerrados (dic 2022)'[Tiempo Resolución])<= 720, "Mensual", "Anual")))
use the SWITCH() statement.
Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523