Forum Discussion
Traffic light KPI with an threshold input
Super UserHi Anonymous ,
The measure can be used in any condittional formatting, since when making the use of colours it identifies the Red, Green and Yellow and converts it to colour coding.
however if you want you can customize the colour by adding the HEX codes of your choice you just need to replace the "Red" by "#FFFFFF" the codes must always have the # and 6 characters.
Hi Miguel,
thanks to your suggestions I was able to create a measure that contains the colors as words.
Unfortunately I can't use it in diagrams, it only allows me to drag & drop the measure in the quickinfo field. Also the conditional formating option doesn't allow to select this measure ....
I also tried to calculate these colors directly in the table as new column. This works fine and it ca be shown in a diagram, because Power BI can count the amount of greens, yellows or reds.
I'd prefer the measure solution, but I can't find the right way to do it. Can you give me any other suggestions?
BR
- MFelix
Hi Anonymous ,
What do you mean by:
Anonymous wrote:
Unfortunately I can't use it in diagrams, it only allows me to drag & drop the measure in the quickinfo field. Also the conditional formating option doesn't allow to select this measure ....
....
I'd prefer the measure solution, but I can't find the right way to do it. Can you give me any other suggestions?You also want to have a count of this values? For that you need a different measure.
Can you share a sample data? and expected result please.
Hey Miguel,
I want to evaluate how many values, can be asserted to be red , yellow or green in dependence of the slice selections.
Then these values should be used for diagrams, e.g. a bar stacked bar chart, that exhibist e.g. 10 green, 20 yellow, and 30 red values.Is it now more clear, what I want?
Tanks & BR