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

Advance card problems with conditions

Hi everyone,

 

I have a problem with some advance cards because i need to show with colors the indicators according this conditions:2018-09-28 (1).png

 

 

Sadly for me, the advance card can only compare the values in one way, > or < or =, but in some indicators i need 2 conditions as you can see in the table.

 

I only think in a DAX formula for the compartions values to solve this issue, but i don´t know which one...

 

By the way, this is the dashboard:

2018-09-28.png

 

 

Thanks for your help!

2 REPLIES 2
Community Support Team
Community Support Team

Re: Advance card problems with conditions

Hi @lfvc1984

Does the color condition follow as below?

item descrpt valor color
1 plazo 105% red
2 produccion 63% yellow
3 facturado 70% green
4 gasto 49% green
5 meta mo 64% red
6 meta oc 93% red
7 flujo 21% green

 

Does the color in your dashboard for your advanced card right?

What do you mean "in some indicators i need 2 conditions as you can see in the table"?

 

Best Reagrds

Maggie

 

lfvc1984 Frequent Visitor
Frequent Visitor

Re: Advance card problems with conditions

Hi Maggie,

 

Thanks for the reply,

 

The color condition that you describe is right.

 

About the 2 conditions, take a look to "Plazo" indicator:

 

For Red, it must be greater than 1

For Yellow, it must be greater than "Facturado"

For Green, it must be less than "Producción", and here is my problem, because advance card only let me put one comparission: Greater, Less or Equal. So the only option i can imagine is create a DAX formula to make a comparition of "Plazo" vs "Producción", and if "Plazo < Producción" generate a value or something.

 

 

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 493 members 3,996 guests
Please welcome our newest community members: