cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sdegroot Frequent Visitor
Frequent Visitor

kpi

Hello,

I am currently using a KPI and it has worked successfully when based it off a percentage goal. Unfortunately, some of the values purposely have no goal and instead of Neutral, the colour coding is formated as the "bad color." 

Can someone help me with the DAX measure for this?

Thank you!

 

Goal blank.PNG

 

 

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: kpi

Hi @sdegroot

After testing, i can't make the same visual as you required.

According to this post, "the Neutral colour is for when you have two target values, if your measure falls between the two it is Neutral Colour, if it is above the higher target it is Good Colour, if below the lower of the two targets it is Bad Colour".

However, blank value can't make sense this way, so i modify the blank value to an alternative value to show neutral color.

9.png

Column = IF(ISBLANK([goal1]),[percetange]-0.01,[goal1])
Column 2 = IF(ISBLANK([goal1]),[percetange]+0.01,[goal1])

 

Best Regards

Maggie

sdegroot Frequent Visitor
Frequent Visitor

Re: kpi

Hello Maggie,

Thanks for looking into it! Were you able to use this in DirectQuery mode too? I wasn't able to use it and I know DirectQuery is very sensitive to adding new columns.

Thanks!

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 257 members 2,588 guests
Please welcome our newest community members: