Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
So I have a pie chart that shows whether a student was on-time or late. I have slicers that have school, day of week, etc. I want to add a visual that updates depending on whatever slicers are selected and gives a letter grade.
For example, if we look at a specific school on Monday, the students have a 99.85% on-time % then they should get an A. But if you change the slicer to select another school and they have a 97.8% on-time % in the pie chart then the visual updates to show a C.
I know it's probably some type of measure, but I can't figure out the DAX. Below are the %'s that align with letter grades
Thanks
Hi @ZEvans12 ,
It's avaiable to realize what you need.
But first pls advise me,based on the data you provided,how to get the result A if you select 99.85%?
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
User | Count |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |