Forum Discussion
Creating Target line with multiple column values
I would need past year and trend line to be static, regardles of selection.
Based on your requirement, you could use a Line and clustered column visual, and add your trend of last year to Line values.
If this is not what you want, please provide us more information about your report, so that we can make further analysis. You can upload a pbix file to Onedrive or any web storage and share the link. Do mask sensitive data before uploading.
Regards,
Charlie Liao
Hi Charlie , thanks for lookin into!
let me try to put this in other way. Issue with the line is that it follows the selection.
I have made one example, on the left is when selection has all the values in it, from 1 to 5. On the right, when I select department or manager that might not have all the values present, in this example 1, 2 and 5 arent present, the target line drops that values also and recalculates its values so it shows 100% at all times. I would like to keep it as on the left, but be able to choose departments/managers without some of the values, its quite normal that you do not have full range of values in your team.
When all data is presentWhen department without 1, 2, and 5 is selected
