Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

KPI not Working

Hello,   I am using the KPI visual, but it is not working.   I have a measure that calculates the spending and another measure that is the goal of that spending.   When I use the cards, it show...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous, 

 

I have struggled with KPI visual in the past. 

What i found useful is as below (There are 100s way for doing the same)

 

For Eg you have 2 measures

MEASURE1 = Which calculates the spending

MEASURE2 = Goal of that spending

 

Create a new Measure and use DAX as below-

IF(SELECTEDVALUE(Sample_Data[Measure1_Spending])<SELECTEDVALUE(Sample_Data[Measure2_Goal]),UNICHAR(9989), UNICHAR(9940))
 
Instead of KPI Cards, Use Card Visuals and filter out whichever ID you wanna show.
 

 

This gives more flexibility to maintain and show KPI's.

 
If you find this helpful, please accept this as answer.
 
Cheers,
Namish B 
Anonymous's avatar
Anonymous
Not applicable
5 years ago

not quite, I would like to stick to the KPI visual, I need to show the information just as that visual lays it out.

 

Please help.

 

Thanks!