If you can instead do bars for the monetary measures and then lines the percentage measures you can do:
- bars in Measure Names/Values
- one percentage metric as the dual axis
- And then make a reference line using the other percentage metric
Alternatively, if you're able to structure you data like this:
You can then normalize your metrics in the worksheet like this where the new normalized values are on the bottom right. You also would then need to hide your axis and make a calculated metric label as well.
I suppose you could try to normalize if you know which measure to use as your basis to find WINDOW_MAX, but could be cautious in case ever out/underperforming as expected.
How can I use a reference line for the second percentage? The value changes every month. Is it possible?
Very interesting solution.
How did you use size option to bars? It´s seems you are just using Sales, but two bars are beeing presented. It could solve my problem.
In my case, I have 4 measures, I would like to present the 2 values in bars and 2 values in lines.
What I could do was to use 2 values in bars (Measure Values), but just one using lines. It seems that tableau doesn´t allow me to use measure values in both axis.
I´m going to prepare a test basis to attach here.