cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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)"):

DateUVTUVT GoalUVT CountUVT>=95Traffic Signal
1/1/20180.9535090.9511
1/2/20180.9548870.9511
1/3/20180.9388290.9510
1/4/20180.9404240.9510
1/5/20180.954750.9511
1/6/20180.9550520.9511
1/7/20180.9419590.9510
1/8/20180.9426730.9510
1/9/20180.9419180.9510
1/10/20180.9430280.9510

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:

trafficSignal.JPG

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
v-yulgu-msft
Microsoft
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.

How to Get Your Question Answered Quickly

 

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

@v-yulgu-msft 

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!

Helpful resources

Announcements
Microsoft Build 768x460.png

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_carousel_with_text (1).png

Charticulator Design Challenge

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

May UG Leader Call Carousel 768x460.png

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.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!