How to create a visual object with a dynamic information

[walterdp]

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 median time to restore tickets. The field Time to Restore was calculated by sustracting end date to start date, add that value in the Y axis and select Median. Then I added the card with various rows and add field Time to Restore and again, change display to show Median. So far, so good.

Problem is that I want to add a card that, based on the previous value, can say if the Median to Restore is

One Day

One Week

One Month

Six Months

One Year

So I guess I need to create a measure that can give me the same value I got in the previous card and based on that result and comparing, display the text specific text.

Something like

If (median of time to resolve) <= 24 then "One Day" else

     if (median of time to resolve) <= 168 "One week" else... 

Problem is, I don't know how to translate that to actual code in Power BI ! 😞

Any help would be much appreciated!

[walterdp · Accepted solution]

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

[lbendlin]

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