Forum Discussion

Icon for Helper V rank

Helper V

6 years ago

Solved

KPI for blank

Hi Friends,

Company	Current	Previous	Percentage	Trend
A	10	20	-1	Down arrow
B	90	30	2	Uparrow
C
D	130	40	2.25	Uparrow

If there is data then below i am getting as expected.

But, I want to show Like below if there is no values.

Trend =

VAR _Trend = CALCULATE(SUM('Table'[Percentage]))

Return

IF(_Trend > 0 ,UNICHAR(9650) ,

IF(_Trend <= 0 ,UNICHAR(9660),

Blank()

))

Here, Condition is i should not convert Blanks to Zero.

Please help. Its an Urgent requirement

Thanks in advance.

Fowmy
6 years ago
BhavyaM

Try this modified measure:

_Trend = SWITCH( TRUE(), [_Diff] = 0, UNICHAR(9660), [_Diff] = BLANK(), "", [_Diff] > 0 ,UNICHAR(9650) , [_Diff] < 0 ,UNICHAR(9660) )
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
YouTube, LinkedIn

13 Replies

Fowmy
Super User
6 years ago
BhavyaM

Modify your trend measure like:

Trend = VAR _Trend = CALCULATE(SUM('Table'[Percentage])) Return SWITCH( TRUE(), _Trend = BLANK(), "", _Trend > 0 ,UNICHAR(9650) , _Trend <= 0 ,UNICHAR(9660) )

________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
YouTube, LinkedIn
- BhavyaM
  Helper V
  6 years ago
  Fowmy
  
  I tried this,
  
  But i am getting (Blank) for Percentage column in the advanced card visual.
  - Fowmy
    Super User
    6 years ago
    BhavyaM
    
    Share you a sample PBIX file to simulating the issue?
    
    ________________________
    Did I answer your question? Mark this post as a solution, this will help others!.
    I accept KUDOS 🙂
    YouTube, LinkedIn