Right-click on Quantity and select New Group
Group types can be bin or list. Choose bin.
Adding a row count measure can show how many rows had quantity in a given range. For example, here we see 216 rows where Quantity = 3.
Select the visual on the left to change how clicking on it causes changes in the visual on the right:
Try clicking Filter
Now you see that selecting bars on the right filters the pie chart on the left:
Change to None and nothing will happen when you select the bars on the left.
Load the Salary Sample data in PowerBI Desktop and create a table showing average salary by company:
Click the down arrow next to salary:
Select Conditional formatting – Background color
Open the Salary Sample and create a Salary By Title view:
And a Title Detail view:
On the Title Detail page, drag Tile to the “Add drill-through field here” area:
Turn on Cross-report drill-through to allow other reports to use this page as a drill-through target:
Now when we go back to the “Salary By Title” page and right-clicking on one of the bars, you’ll see the drill-through option:
Dashboard Tile Flow will automatically reposition tiles to keep your dashboard organized. To turn it on, click the elipsis next to one of your dashboards, then choose settings.
Scroll down and click to turn on tile flow:
On the Power BI Service, select a report. Then, on the navigation bar, select the ellipsis icon and then Pin to a dashboard:
Obseve the note – “Pin live page enables changes to reports to appear
If I go back to PowerBI desktop, make a change, and publish, the change will be reflected on the dashboard:
The new changes are reflected on the dashboard:
Select File, then Options and Settings
Uncheck “Enable search for the filter pane”
After you click OK, you should see that the search box no longer appears in the filter pane:
Hide Filter for Report Readers
Easy, just click the eye icon:
Lock or Disable a Specific Filter for Report Consumers
Again, easy, just click the Lock icon to prevent a report consumer from changing it.
Starting with this workbook and on the Insert tab select Image.
Use this paperclip image.
Turn the action on,
Turn on the action, set he type to bookmark, and choose Page1 or Page2
In the final view, the paperclip image can now be used to navigate to another page.
Connect to the shipping cost data
Create a couple pages:
Add bookmarks for Page 1 and Page 2
Rename the bookmarks so that it’s clear which goes with which page
On Page 3, add buttons of type Bookmark:
Using the Format button menu, set the bookmark action:
Turn on the title and set it to Page1:
The view now looks like this. Hold down the control key and click the bookmark button to navigate.
You don’t need to use bookmark buttons. You can also use different button types:
With the Arrow button selected, set the Action type to Boomark:
Select Page1 or Page2
CTRL+click will send you to Page 2
Create an average salary by title bar chart:
Create a second report page with a card. Under Page Information, set tooltip to On.
Next we need to specify fields that will trigger the tooltip. Switch to value and drag title to the tooltips fields area. We want the tooltip to appear when we mouse over the title, so drag title to the “title” to the “Add data fields here” area.
Now when we go back to the bar chart we see this:
One problem – the tooltip is gigantic! How to make it a reasonable size? Go back to the tooltip page and set the page size to tooltip:
Should look more reasonable now!