I have a table to show that has the below format (sorry for the black stripes) and to give you a bit of background, this data is used as a part of a bonus system to reward the different sellers according to certain parameters:
and i have the following questions if it’s possible to do with Power BI:
1.Can a thicker line be done to delimitate quarters and the basic columns that are on left (light blue ones)? I saw that the thickness of the vertical grid lines can be adjusted but i dont know if this it’s possible per group of columns?
2. Can a filter be added that put all values in the table as zeros? with which formula could I do this?
3.As you can see, I have 2 colors in the bonus column (conditional formatting), can a third color be added based on a condition that is not numerical like modified value=1?
4.Can totals be added only for specific columns? in this case for “max_value” and each “Bonus” column per quarter? If I add subtotal, it adds a sub total per each row and grand total I cant add the grand total.
Thanks in advance!!!