Forum Discussion
Helper IVone value on secondary axis
itsmeanuj , if you plan to use the legend, it will show all one axis. You can create a measure filter with product C and use that on secondary axis
Helper IVnandic amitchandak - With this approach, I will not be able to show individual products in legend. My data has 10 products out of which one product's sales are way too high to put it on a similar axis with other products. I want to show all the products in legend and product with very high sales on the secondary axis.
Resident RockstarHi itsmeanuj ,
There must be better solution, but here is some kind of alternative.
You create 2 new columns in fact table: one returns sales amount only if product <> product C, second column returns sales amount only if product = product C. (if product C has much higer value comparing to other products)
You create 2 charts - one displays first column, second displays second column (this way you get all products on both charts, but chart columns are displayed only if sales amount > 0).
You need to configure some options on second chart (background transparent 100 %, remove title, axis x title, set y axis right).
Last step is to set second chart over first chart.
Note: this way you will not be able to click on both charts to filter other objects on the report, only on the one which is on top.
Screenshots:
Cheers,
Nemanja