Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
nawlins1976
Frequent Visitor

Cards With States - Separate Conditions for Multiple Measures

Hello, 

I am builing a visualization using Card with States by OKVIZ. The card uses several measures, however I would like each of those measures to have a different conditional formatting condition. 

 

 

Ex:

In Progress > 150 then Red

Overdue > 2 then Red

2021-02-04_9-44-58.png

 

Is this possible?

Thanks in advance.

1 ACCEPTED SOLUTION

Hi @nawlins1976 ,

 

Not really sure if this is possible with the free version of the card with stakes do you have the payed or free version?

 

What I did since you need to hjave it in a single visualization was to create a table visual and make some formatting.

 

Final result is bvelow if you want I can share what I did.

MFelix_0-1612802358501.png

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

6 REPLIES 6
v-kelly-msft
Community Support
Community Support

Hi  @nawlins1976 ,

 

Change the setting under the condition of format:

v-kelly-msft_0-1612773137656.png

 

For the reference ,check the video below:

https://www.youtube.com/watch?v=ATrzjq76nMg

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Thanks, Kelly. However those setting will only allow for conditional formatting for "multiple values". I would need a condition for In Progress and another condition for "Overdue". 

Hi  @nawlins1976 ,

 

After testing,only card visual can achieve your formatting requirement,see below reference:

https://radacad.com/enhance-the-card-visual-in-power-bi-with-conditional-formatting

 

If you do need to generate in one card,better propose an idea via below link:

https://ideas.powerbi.com/ideas/

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

MFelix
Super User
Super User

Hi @nawlins1976 ,

 

Why don't you just create a card visualization for each measure and apply the condittional formatting to the brackground instead of using a custom visualization? It' much easier to setup and there is no need of manual updates if the visualization or the Power BI is updated.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Thank you MFelix, however, I'll need both measures on one card as it will be pinned to a dashboard. Since both of these measures are focused on different aspects of the same metric, they need to be on the same card.

Hi @nawlins1976 ,

 

Not really sure if this is possible with the free version of the card with stakes do you have the payed or free version?

 

What I did since you need to hjave it in a single visualization was to create a table visual and make some formatting.

 

Final result is bvelow if you want I can share what I did.

MFelix_0-1612802358501.png

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.