Hi All,
I have created some example data which can be seen in the table below...
Team | Owner | Product Target 1 | Product Target 2 | Product Target 3 | Product Target 4 |
Football | Christiano Ronaldo | Paid | Unpaid | Unpaid | Paid |
Football | Robin Van Persie | Paid | Unpaid | Paid | Paid |
Football | Lionel Messi | Paid | Unpaid | Paid | Paid |
Football | Robert Lewandowski | Paid | Paid | Paid | Paid |
Basketball | Michael Jordan | Unpaid | Paid | Paid | Unpaid |
Basketball | Lebron James | Unpaid | Paid | Paid | Unpaid |
Basketball | Kobe Bryant | Unpaid | Unpaid | Paid | Unpaid |
Basketball | Kyrie Irvine | Unpaid | Paid | Unpaid | Paid |
Golf | Rory McIlroy | Unpaid | Paid | Unpaid | Paid |
Golf | Tiger Woods | Paid | Paid | Unpaid | Paid |
Golf | Graham McDowell | Paid | Unpaid | Unpaid | Unpaid |
Golf | Someone Random | Paid | Unpaid | Unpaid | Unpaid |
I am currently showing if an employee has been paid thier bonus like the example below....
Any chance anyone has came across this before and has a more appealing format of presenting this information?
Any help would be greatly appreciated!
Many Thanks & TIA!
Taylor
Solved! Go to Solution.
Hi @Ttaylor9870 ,
You could use conditional formatting to highlight the specific value.
Apply conditional table formatting in Power BI - Power BI | Microsoft Learn
Hi @Ttaylor9870 ,
You could use conditional formatting to highlight the specific value.
Apply conditional table formatting in Power BI - Power BI | Microsoft Learn
Hi @Ttaylor9870 ,
I would remove totals and subtotals, set a slicer by Team and calculate the percentage number of "PAID" / number of Product.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
125 | |
78 | |
68 | |
56 | |
56 |
User | Count |
---|---|
200 | |
104 | |
85 | |
80 | |
77 |