October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
Hi
I am a newbie..
I have for 30 drpartments the profit for each of the last 5 years. Management wants to see on one report the profit by dept for each of the 5 years. So dept 1 and its five profit results, the same for depts 2 through 30 and all on one report.
Does anyone gavecz suggestion as to which kind of visual would be best
Thank You
Hi @abaken ,
I think you shoud lgo with the area chart, clustered bar chart by taking the x axis as the years column and on the y axis take the profit number and on the legend take the department names,
Regards,
Nikhil Chenna
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!