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?
Good morning Ty
I looked through your attachment and noted that the author recommended a sheet swap when the axis changes from values to %
if you are not familiar with sheet swapping there is a link below that will walk you through the process
Let me know if that worked