I have two sheets that are combined in the vertical layout container on my dashboard. I have used this function because I needed the Y-axis to change from a number to a percentage as the parameter changed.
Below I have attached the word file that I used to get the dynamic formatting. As shown in the word file, I duplicated the sheets then filtered the parameters( one sheet having Sales and Gross Profit and the other having Gross Margin) so I could change the number format on the axis. My problem now is that I also had a filter field shown in my worksheets so the user could switch between different product types. I now have two separate filters on my dashboard. One controls the product type for Sales and Gross Profit, the other controls for gross margin. Is there anyway that I can get around this issue?