2 Replies Latest reply on Jun 10, 2018 7:15 PM by malvika.tripathi.0

    Multiple measures in Dual Axis chart

    malvika.tripathi.0

      I am trying to recreate a financial dashboard using the Superstore dataset based on the dashboard here : Track profit, loss with an intuitive CFO dashboard | Tableau Software

      As the dataset is structured differently than the Superstore dataset, I am not able to understand how to display Profit Margin, Sales and Profit in a dual axis as shown in the dashboard above. I have (un)successfully tried creating the dual axis with Measure Names and Values filter. But it is incorrect as it shows an inflated axis of Sales and Profit. I want to show Profit as a component of Sales in the bar chart (as I was able to achieve in Sheet 2 of the workbook). Do I need to use LOD calculations? Any pointers will be appreciated. Thanks in advance!