KPI not Working

[LuisGerardoSR]

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 shows the correct values for each measure, but when I put them in the KPI is does not show the correct data.

Not sure how to fix this.

Thanks!

[v-stephen-msft]

Hi @LuisGerardoSR ,

It may be because you didn't sort by FiscalMonth. KPIs don't have a sort option. You'll need to start again and sort by FiscalMonth before you convert your visualization to a KPI.

Reference: Create key performance indicator (KPI) visualizations

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[NamishB]

Hi @LuisGerardoSR, 

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 

[LuisGerardoSR]

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!