Now that you have create a few measures in Power Pivot, let’s use them to tell the staffing story by department. In this lesson, we will focus on,
- Information goals & Visual layout
- Interactions in Power BI
- Formatting visuals
- Cards
- Charts
- Tables
- Slicers
- Working with pictures
Author: Chandoo
My name is Chandoo. I am going to make you awesome in Excel, VBA, Dashboards, Power BI & Power Pivot and answering your questions.
I live in Wellington, New Zealand. It is a beautiful, small city on the southern edge of the world. I run my own Excel Consulting & Training business from here.
I am married to my college sweet-heart, Jo. We have 2 kids – twins. They are 10 years old now. They are busy creating new worlds with lego bricks or playing or learning. We (Jo &I) are busy with cooking, eating, walking, talking and reading.
View all posts by Chandoo
While adding a slicer, there are buttons which appear for each category. To select all we have to drag accross all buttons to get everything selected. Is it possible to add a button which says All instead of sliding across and selecting all the buttons?
If you click on the format button when the slicer is selected, and in selection controls chose show Select All Option
Hi Chandoo, thanks for the awesome video. I tried to link the jpg files saved on SharePoint to a Dashboard that i want to build, but the images didn’t show up even though I have followed Your instruction by convert the hyperlinks to Image URL. What is the reason? Is it because files on local SharePoint would not work?
Hope for Your prompt advice. Stay safe in the coronavirus season.
Hi Chandoo,
I am not able to link the pictures into dashboard. The picture in my laptop. Please assist.
Thank you
Is this bonus lesson not included with the Excel School 2.0?