Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
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
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!
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |