When I tried to create a Power View report using Excel 2016, I couldn't find where is the Power view option from Ribbon in Excel 2016?
Did Microsoft remove it from normal ribbon view? ðĢI feel that this is an important option and it should be in normal ribbon view.
1. Click Excel -> Blank work book -> File -> Customize Ribbon -> Choose from Commands drop down -> Select Commands not in the Ribbon -> look for "Insert a Power View Report" -> I am adding it in a group which I created called "Reports" as shown below:
That's it, you should be able to add Power View reports from the ribbon as usual in a click.
Bonus for the readers of this article:
Where is the Power Query option in Excel 2016?
If you use Excel 2013, after enabling Power Query after installation you will see the option in a separate tab as shown below:
But in Excel 2016, Microsoft changed it as shown below:
ðĄð If you are interested reading about Power Query and Power Map, read this article
Happy reading! ð
0 comments:
Post a Comment
Dear Readers,
I LOVE to hear from you! Your feedback is always appreciated. I will try to reply to your query as soon as possible.
1. Make sure to click the "Notify me" check box at the right side to be notified of follow up comments and replies.
2. Please Do Not Spam - Spam comments will be deleted immediately upon review.