Visualization help

[vjnvinod]

Dear communnity

screenshot which you see here is something i find out in category list sample one

my question is how do i add indicators(up & down) shown in this table to my metrics/table in my dashboard.

[v-danhe-msft]

Hi @vjnvinod,

Based on my research, you could refer to below link that could use the UNICHAR function to show the symbol in table:

https://community.powerbi.com/t5/Community-Blog/Power-BI-Desktop-DAX-Using-Unicode-Arrows-as-Measure...

Regards,

Daniel He

[vjnvinod]

@v-danhe-msft

thanks this helps, but  as i see unichar measure is used in a differnt coloumn but i want something like below.

can you help creating a pbix file & show me if this possible to do .

[v-danhe-msft]

Hi @vjnvinod,

The measure has a conditional formatting:

You could download the pbix file to have a view.

Regards,

Daniel He

[vjnvinod]

@v-danhe-msft

super helpful, but then i realise my % format is not picking up correctly. i tried doing it from modelling tab, but that seems to be freezed.

how do i fix this?

thanks for your help

[v-danhe-msft]

Hi @vjnvinod,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[vjnvinod]

@v-danhe-msft

Unfortunately it doesn't help, see below how this is turning up?

[vjnvinod]

@v-danhe-msft

Appologies, i had some login issue recently due to power BI sign on change to AAD active accounts.

the issue is not solved yet.

take a look at the pic, how, this is coming up, % format is not picking up correctly and also the decimal point(which in my case should be 1 decimal point)

below are the measures i have used, but not able to spot any error

 Arrows = SWITCH(
   TRUE(),
    ISBLANK([Growth])
     || ISBLANK([Growth]),BLANK(),
    [Growth] = 0, "No Data",
    [Growth] >= 0,UNICHAR(9650),
    [Growth] <= 0,UNICHAR(128315),
   BLANK()
  )

Growth =
VAR __BASELINE_VALUE = SUM('Inbound'[TER_PFYTD_Constant])
VAR __VALUE_TO_COMPARE = SUM('Inbound'[TER_FYTD_Constant])
RETURN
 IF(
  NOT ISBLANK(__VALUE_TO_COMPARE),
  DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)
 )

Growthnew = CONCATENATE(CONCATENATE([Growth],"%"),Inbound[Arrows])

[v-danhe-msft · Accepted solution]

Hi @vjnvinod,

Try to modify the [Measure]:

Measure = CONCATENATE(CONCATENATE('Sales Data'[Arrows2],"%"),[Arrows])

Result:

Regards,

Daniel He

[PattemManohar]

@vjnvinod I think it is a custom visual "Power KPI Matrix". 

[vjnvinod]

@PattemManohar

Tried but doesn't work, have you worked on it before?

[PattemManohar]

@vjnvinod Oh ok  !! Yes, I've had some play with it as part of exploring custom visuals.

[PattemManohar]

@vjnvinod Might be helpful

https://community.powerbi.com/t5/Desktop/How-to-create-status-indicator-field/td-p/289572