Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Employee
Employee

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.