cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## Ratio of Values Greater Than Number with Traffic Light Indicator

I have a date slicer on my dashboard that controls the date range that I would like to perform summary calculations on. One of the summary calculations I would like to do is to determine whether the proportion of values in the UVT column that are greater than 0.95 (for the selected date range) is greater than 0.9. If the proportion of UVT values >0.95 is >0.9, then I would like to have a traffic light style indicator that is green, and red if the proportion is less than 0.9. Sample data is below (note: traffic signal is "=unichar(11044)"):

 Date UVT UVT Goal UVT Count UVT>=95 Traffic Signal 1/1/2018 0.953509 0.95 1 1 ⬤ 1/2/2018 0.954887 0.95 1 1 ⬤ 1/3/2018 0.938829 0.95 1 0 ⬤ 1/4/2018 0.940424 0.95 1 0 ⬤ 1/5/2018 0.95475 0.95 1 1 ⬤ 1/6/2018 0.955052 0.95 1 1 ⬤ 1/7/2018 0.941959 0.95 1 0 ⬤ 1/8/2018 0.942673 0.95 1 0 ⬤ 1/9/2018 0.941918 0.95 1 0 ⬤ 1/10/2018 0.943028 0.95 1 0 ⬤

I have watched a couple of videos on how to create traffic light indicators in a table with conditional formatting to change the font color of a bullet placed in a cell, but the conditional formatting options available are much simpler than the conditions that I want to test. I started to implement this bullet font color method by getting the sum of values for the selected date range and the sum of values >= 0.95 for that date range, but I can't figure out how to change the font color based on the ratio of those two numbers. What I have on the dashboard is below:

I can get the count numbers to update based on the date slicer, but I'm not sure how to get a column in that table that shows the ratio of values >= 0.95 to total values, so that I can use it for conditional formatting of the bullet cell. Please let me know if you have any input on how to get the traffic light indicator working. Thanks!

2 REPLIES 2
Microsoft

Hi @Anonymous ,

Sample data is required to test. And if there existing measures or calculated columns in your test, please show the corresponding formulas.

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Thank you for the feedback. I have included a table with sample data in my original post and adjusted some of the wording to make it clearer. I don't currently have any measures or calculated columns in my table.

Thanks!

Announcements

#### Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

#### Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

#### What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.