Forum Discussion
Traffic light KPI with an threshold input
Hey Miguel,
thanks again for your fast response.
Since I want to use the outcome of the measures for diagrams (e.g. a bar chart), I wonder if I can use those measures, beacuse PowerBI asks for values. So I can't drop this measures in the field value because they contain words and not values ....
I'd like to exhibit the overall amount of the green, yellow and red values ...
What would you suggest?
BR
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