Forum Discussion
Solved
Ignoring Legend filter
Good day all, I currently have a stacked bar chart with two products having the following annual sales: Product Year 1 Year 2 Year 3 A 10 10 10 B 10 20 30 I also have...
madscientist , you can unpivot the date have a year in row
Hi madscientist ,
Try to unpivot your table like:
And you measure will work.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
madscientist , you can unpivot the date have a year in row
amitchandakHi - in the underlyding dataset, year is already in a row via a calendar table (along with all other date-related attributes).