Help with Indicator via a pie chart

[annlois]

I am trying to make a "traffic light" for our service and in order to show the final indicator - there are 3 categories to determine.

Whenever one condition is on red or yellow, then the service becomes "red" or "yellow"

Maybe anybody has an idea how this can be implemented?

 I'm thinking of creating a measure to get the final indicator but not sure yet how to make the if-else statement for it.

Thanks!

[TomMartens]

Hey @annlois ,

to be honest, I have my difficulties fully, understand your requirement.

Please consider creating a pbix file that contains sample data, but still reflects your data model (tables, relationships, calculated columns, and measures). Upload the pbix to onedrive or dropbox and share the link. If you are using Excel to create the sample data instead of the manual input method, share the xlsx as well. Do not forget to explain the expected outcome based on the sample data you provide.

Regards,

Tom

[TheoC · Accepted solution]

Hi @annlois 

This article will provide you with the steps you need to apply: https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...

Hope this helps 🙂

Theo