Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In Data Visualization, which one of the QV Demos, there is a Scatter Chart "Two dimensions and three expressions" in sheet "Relationship".
When I select a rep, the legend in this chart will be change to "Year", and the color of these 2 dots of this 1 rep will be different.
How can I keep the legend "Sales Rep" when I select only 1 rep?
hei
not extly what you asked for but maybe an idea
when one sales person is selcted
add his name to the chart title
then you will get also the legend pointing more clearly on the years
and also the sales rep
just change the title to
='Sales and Margin Movements from ' & (
Max(Year)-1) & ' to ' & Max(Year) & ' ' &if(isnull(only([Sales Rep Name]))=0,[Sales Rep Name])
Thank you liron baram, but I prefer achieve in chart to in title.