Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Traffic light KPI with an threshold input

Dear community and P-BI specialists,   I am trying to create a traffic light indicator for some data.   The concerned Excel file contains several columns with data. I want to associate the values...
Need Help
Tips and Tricks
MFelix's avatar
MFelix
Icon for Super User rankSuper User
5 years ago

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.

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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