Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
87 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
124 | |
107 | |
60 | |
55 |