{"id":231032,"date":"2022-10-27T19:00:00","date_gmt":"2022-10-27T18:00:00","guid":{"rendered":"https:\/\/www.virtualworlduk.co.uk\/wordp\/?p=231032"},"modified":"2022-10-27T14:20:49","modified_gmt":"2022-10-27T13:20:49","slug":"skyline-basic-power-bi-report-part-3","status":"publish","type":"post","link":"https:\/\/www.virtualworlduk.co.uk\/wordp\/skyline-basic-power-bi-report-part-3\/","title":{"rendered":"Skyline \u2013 Basic Power BI Report \u2013 Part 3"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

This continues the work that we have been doing to create a basic Skyline Power BI report in part 1:<\/p>

https:\/\/www.virtualworlduk.co.uk\/wordp\/?p=230985<\/a><\/p>

and part 2:<\/p>

https:\/\/www.virtualworlduk.co.uk\/wordp\/?p=231022<\/a><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Build the Visuals<\/h4>

If you’ve been following this series so far, then you will have seen us gather the data export from Skyline, create parameters and manipulate the data we took from Skyline as queries and measures in Power BI.<\/p>

Now we are onto the stage of building the actual visuals, the method of showing the data we’re manipulating.<\/p>

Title<\/h5>

We’ll start simple by creating a title for our report.\u00a0 For this we will go into the ‘Home’ menu item at the top of the screen and select the ‘Text box’ option.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

When you click the ‘Text Box’ option, it will immediately create a text box in the Top Left hand corner of the screen.\u00a0 This is fine for now, as we can adjust it later.\u00a0 Click in the text box and type:\u00a0 Skyline Findings Summary<\/p>

The text will appear quite small, so feel free to adjust the text size and colour as you wish.\u00a0 I used Segoe UI with a size of 28 and a dark blue colour (remember to swipe over your text before making changes).\u00a0 You can now use the handles around the edge of the text box to adjust the size of the box, and drag and drop the box to position it on the page.\u00a0 Alternatively, you can use the ‘Format’ functions on the right of the page to enter specific sizes and positions of the box.\u00a0 Under size, my box is set to:\u00a0 Height:\u00a0 63, Width: 469<\/p>

Under Position, my box is set to:\u00a0 Horizontal: 48, Vertical: 4<\/p>

You should now have something similar to below:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
Findings Box<\/h5>

Let’s move onto something a little more complex now and create the central ‘Findings Box’.<\/p>

This uses the ‘Table’ visual from the ‘Visualizations’ section on the right of the screen.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Clicking on the ‘Table’ option will create a blank table entry on the Power BI page, with text explaining to select or drag fields to populate this visual… so we’ll select some fields.<\/p>

Expand the ‘Fields’ section on the right of the screen where we see the queries and measures we created previously.\u00a0 All of the fields we want to add to the table are taken from the ‘LatestFile’ query.\u00a0 Expand the ‘LatestFile’ query to show all of the fields underneath, then put a tick in each of the following fields in turn:<\/p>

Finding Id
Issue Description
Severity
Number of Affected Objects
Risk if no Action Taken<\/p>

You will see that the fields have expanded past the edge of the table and scroll bars have been added automatically.\u00a0 Also, the table doesn’t look the same as we have it in the target look, so let’s adjust it.<\/p>

Let’s start with size and position, similar to how we did it before, except as this is a more complex visual, you need to switch across to the ‘Format Your Visual’ view under the ‘Visualizations’ section on the right of the screen.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Within that section, we also have ‘Visual’ and ‘General’, to modify the size and position, we’ll switch over to the ‘General’ page, then expand the ‘Properties’ item.<\/p>

For my version, I created the Size as:\u00a0 Height: 574, Width: 939<\/p>

For the Position, I have it as: Horizontal: 11, Vertical: 81<\/p>

(please note that the Height may not seem right until you update the position details)<\/p>

So, we now have a larger table on the report but it still doesn’t look the same, so let’s adjust the rest of the visual.<\/p>

Whilst we are still in the ‘General’ section, lets go to the ‘Effects’ section and make sure that ‘Background’ is On and the background colour is White.\u00a0 We can then then go to the ‘Shadow’ section, make sure that it is On, the colour is Black, with an ‘Offset’ of:\u00a0 Outside, and a ‘Position’ of:\u00a0 Bottom Right.<\/p>

This provides a shadow around the table and makes the background of the table white.<\/p>

Next we need to switch back to the ‘Visual’ section to adjust some of the other settings.<\/p>

Under ‘Style presets’ select:\u00a0 Condensed<\/p>

Under ‘Grid’ make sure that ‘Horizontal gridlines’ is On, the colour is set to Grey and Width is 1.<\/p>

‘Vertical gridlines’ should also be On, with colour set to Grey and Width set to 1.<\/p>

Next we move onto the ‘Values’ section.\u00a0 Make sure that the font is set to ‘Segoe UI’ with the size being 9.\u00a0 Text colour should be Black and ‘Text wrap’ should be On.<\/p>

Under ‘Column Headers’, the Font should be ‘Segoe UI’ with a size of 9.\u00a0 The Text colour should be White and the Background colour should be Black.\u00a0 The ‘Header Alignment’ should be centered and Text Wrap should be On.<\/p>

Under ‘Totals’, this should be marked as Off.<\/p>

We shouldn’t have anything to change in the ‘Specific Column’ section – but this is where you could change a certain column to have their data centered or in a different colour, if you wanted.<\/p>

Unfortunately, there isn’t a way to specify the exact column width by a number in Power BI, and therefore you need to hover your mouse over the separator between the columns to then drag the width of the column accordingly.\u00a0 Repeat this process for each of the columns so that all of the data appears in the size of the table we have created without the need for scroll bars.<\/p>

If you have a lot of findings being shown then you will not be able to get rid of the vertical scroll bar… this is expected.\u00a0 You should now have a page that looks similar to below:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
Total Findings Available<\/h5>

As you can see, the report is now starting to take shape.\u00a0 We’re now going to focus on the ‘Total Findings Available’ visual at the top right of the report.<\/p>

We’re actually going to focus just on displaying the numbers and we’ll tidy up the text boxes that are associated with these afterwards.\u00a0 I am aware that we can add text to a Card visual to avoid using a Text Box but this is an early version of my report that we are trying to replicate and this was the method used.<\/p>

For this visual we are using the ‘Card’ visual.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

When you click the ‘Card’ visual, it will place a card on the page.\u00a0 Once again we are going to select a field to add to the card.\u00a0 This time we will select a field from the ‘TotalFindings’ query on the right.\u00a0 With the field that we are going to select being the ‘TotalFindings’ field – this should not have an icon next to it.<\/p>

You will see that the visual will have a number and ‘First TotalFindings’ listed underneath.\u00a0 Let’s adjust the formatting of this (as it is also quite large).\u00a0 Switch across to the ‘Format you visual’ section under ‘Visualizations’<\/p>

This time we’ll start on ‘Visual’ page.\u00a0 Under the ‘Callout value’ section, change the font to be: DIN with a size of 30 and colour being Black.<\/p>

Under the ‘Category label’ section, make sure that this is Off.<\/p>

Switch across to the ‘General’ page.\u00a0 Under ‘Properties’ make sure that the Size is set to:\u00a0 Height: 45, Width: 100<\/p>

Position is set to:\u00a0 Horizontal:\u00a0 1165, Vertical: 58<\/p>

This should result in the card appearing in the top right of the screen and suitably sized<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
Your Findings<\/h5>

Now we are going to do a similar card but to show your active findings.<\/p>

Start by creating a blank card as we have done previously.<\/p>

For the field to select for this, we are going to use the ‘Your Findings’ field under the ‘TotalFindings’ query on the right.<\/p>

This should provide a number and ‘Sum of Your Findings’ underneath.<\/p>

We’ll now adjust the card to position it and adjust the size etc. as we did before.<\/p>

Under ‘Visual’, for the ‘Callout value’ make sure that the Font is DIN and the size is 30, with a colour of Black.\u00a0 Under ‘Category label’ make sure that this is Off.<\/p>

Switch to ‘General’, the Size should be:\u00a0 Height: 45, Width: 100<\/p>

The Position should be: Horizontal: 1165, Vertical: 123<\/p>

We should now have a page looking similar to below:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
Total Pie Chart & Value<\/h5>

Now we’re going to move onto creating our first pie chart and calculation text.\u00a0 This pie chart will show the percentage of your findings against the total number of findings available.<\/p>

We will be using the ‘Donut Chart’ visual for this.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

If you click on the ‘Donut Chart’ option it will put a blank chart on the report similar to the others we have done.<\/p>

Let’s start by adding the fields.\u00a0 Both fields will be coming from the ‘TotalFindings’ query and you should click the fields in the following order:<\/p>

Your Findings
Other Findings<\/p>

Keeping this with the default settings looks completely different to the look we are trying to create and therefore let’s go through and adjust the look and settings.<\/p>

Switch to ‘Format you visual’ and under the ‘Visual’ section make sure that Legend is Off and that Detail labels are also Off.<\/p>

Under ‘Slices’ you should make sure that ‘Your Findings’ is coloured in Light Blue and that ‘Other Findings’ is coloured in Grey.\u00a0 You should also expand the Spacing section to make sure that the Inner Radius is set to 77px.\u00a0 This will adjust the thickness of the donut.<\/p>

If we now switch over to the ‘General’ page, we can adjust the Size to be:\u00a0 Height: 187, Width: 194<\/p>

The Position can then be adjusted to be:\u00a0 Horizontal: 976, Vertical: 4<\/p>

Moving down, Title should be switched to Off.\u00a0 Under Effects, Background should be switched to Off.<\/p>

To finish off this chart, we just need to put the percentage in the middle.\u00a0 The percentage figure actually uses a ‘Card’ similar to before and therefore click on the ‘Card’ option to create a new card on the report.<\/p>

The field that will be used for this card is under the ‘TotalFindings’ query and is called:\u00a0 %TotalFindings<\/p>

Once selected, switch to ‘Format you visual’, under ‘Callout Value’ select the font as DIN with a size of 20, colour Black.<\/p>

Make sure that ‘Category label’ is Off.<\/p>

Under the General page, we want to set the Size to: Height: 35, Width 101<\/p>

Position should be set to:\u00a0 Horizontal: 1022, Vertical: 81<\/p>

You should now have a donut pie chart showing with a percentage figure in the middle.\u00a0 We’ll now repeat the process for the Critical, Moderate and Trivial donut charts.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
Critical Pie Chart & Value<\/h5>

Once again we are going to use a ‘Donut Chart’, so select this from the ‘Visualizations’ sheet.<\/p>

We will be using two fields from the ‘TotalFindings’ query for this chart and therefore select the following fields in the displayed order:<\/p>

Critical
CriticalLeft<\/p>

Switch ‘Format you visual’ to adjust the configuration of the donut chart.\u00a0 Make sure that Legend and Details Labels are both set to Off.<\/p>

Under Slices, make sure that Critical is a Red and CriticalLeft is a Grey, then go into Spacing and make sure the Inner Radius is 77 px.<\/p>

Switch to the ‘General’ page and make sure that the Size is as follows: Height: 168, Width: 177<\/p>

Then make the Position: Horizontal: 1031, Vertical: 317<\/p>

Move down to the ‘Title’ option, make sure that it is On.\u00a0 Under the Text box, enter:\u00a0 Critical
Make sure that the Heading is: Heading 3
Font should be DIN with a size of 14, colour should be Black and it should be Centered.<\/p>

Make sure that Header icons and Tooltips are Off, along with Background under Effects being set to Off.<\/p>

For the percentage in the centre, we’ll use a ‘Card’ again and therefore click that to create a new card.<\/p>

The field we are going to use for this is under the ‘TotalFindings’ query and is called: %Critical<\/p>

Format the visual, the Callout value should have a font of DIN with a size of 17, colour Black.\u00a0 The Category label should be Off.<\/p>

Under ‘General’, the Size should be: Height: 34, Width: 102<\/p>

Position should be: Horizontal: 1068, Vertical: 393<\/p>

Make sure to go under Effects to switch the Background to Off.<\/p>

You should now have a Critical donut chart created.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
Moderate Pie Chart & Value<\/h5>

Now we’ll repeat the same process as before but for the Moderate results.<\/p>

Insert a new donut chart as before.\u00a0 The fields to be added to this chart are from the ‘TotalFindings’ query and are:<\/p>

Moderate
ModerateLeft<\/p>

Make sure that Legend and Detail labels are Off.\u00a0 Under Slices, choose an Orange colour for Moderate and Grey for ModerateLeft, under Spacing make sure that the Inner Radius is 77 px.<\/p>

Under ‘General’, set the size to be: Height: 170, Width: 177<\/p>

Position: Horizontal: 958, Vertical: 485<\/p>

Under Title, make sure the Text says:\u00a0 Moderate<\/p>

Heading should be: Heading 3<\/p>

Font should be DIN with size 14, text colour should be Black and it should be centered.<\/p>

Under effects, make sure that Background is Off.<\/p>

To add the percentage figure in the centre, we’ll use another ‘Card’, therefore click that to create a new Card.<\/p>

The field for this one is: %Moderate<\/p>

Under Visual, change the Callout value to make sure it is Font of DIN, size 17, colour Black.\u00a0 Make sure Category Label is Off<\/p>

Under General, make the Size: Height: 34, Width: 102<\/p>

Position should be: Horizontal: 996, Vertical: 561<\/p>

Under Effects make sure that Background is Off.<\/p>

You should now have a Moderate donut created.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
Trivial Pie Chart & Value<\/h5>

The final donut chart we are going to create is for the Trivial findings.\u00a0 Once again, click the Donut Chart option to insert a new donut chart.<\/p>

The fields used on this chart are from the ‘TotalFindings’ query and are:<\/p>

Trivial
TrivalLeft<\/p>

Under Visual, make sure that Legend and Detail labels are Off.<\/p>

Under Slices, choose a Dark Yellow for Trivial and a Grey for TrivialLeft<\/p>

Make sure to change the Spacing so that Inner Radius is 77px.<\/p>

Under General, the Size should be: Height: 170, Width: 177<\/p>

Position should be: Horizontal: 1103, Vertical: 485<\/p>

Under Title, make sure the Text is:\u00a0 Trivial<\/p>

The Heading should be: Heading 3<\/p>

Font should be DIN with a size of 14, colour Black and centered.<\/p>

For the percentage information, we are going to use a ‘Card’ so select that as we’ve done before.<\/p>

The field to use is taken from the ‘TotalFindings’ query and is called: %Trivial<\/p>

Under Visual, the Callout value should have font of DIN, size 17, colour Black.<\/p>

Category label should be Off.<\/p>

Under General, the size should be: Height: 34, Width: 102<\/p>

Position should be: Horizontal: 1141, Vertical: 561<\/p>

Under Effects make sure to switch Background to Off.<\/p>

You should now have a Trivial donut chart created.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Your report should now look similar to this:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
Your Findings Trend<\/h5>

The last of the charts that we are going to add to the report is the ‘Your Findings Trend’ chart.\u00a0 This is a line chart that will show how the number of findings in your environment is changing over time.\u00a0 When you have more than one Skyline exports in your export folder then it will show a line, with just a single export it will only show a dot for where you are.<\/p>

As mentioned we’ll use the ‘Line Chart’ visual for this and therefore select this from the ‘Visualizations’ pane.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

For a line chart we need to provide a field for the X-axis and one for the Y-axis.\u00a0 Rather than just clicking the relevant field, we are going to drag and drop the field to the relevant part of the line chart inputs.<\/p>

Both elements are going to come from the ‘FindingsCount’ query.\u00a0 First up we will drag and drop the ‘Date’ field across to the X-Axis.\u00a0 When it is there, we will click the ‘X’ next to Year and Quarter to keep just the Month and Day visible.<\/p>

We’ll now drag and drop the ‘Count’ field across to the Y-Axis.\u00a0 At this point you should now see a dot in the centre of the line chart along with Months, Days etc., we’ll sort those out next.<\/p>

Under Visual, we’ll make sure that X-axis, Y-axis and Secondary y-axis are all Off.\u00a0 Within each of those items, also make sure that Title is switched to Off.<\/p>

Under General, we want the Size to be: Height: 65, Width: 275<\/p>

Position should be: Horizontal: 975, Vertical: 217<\/p>

Title should be Off.<\/p>

You should now has a line chart on your report… admittedly at this point it will just look like a dot on the page.\u00a0 You page should now look similar to below:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
Final Text Boxes<\/h5>

The final item as part of our page design is to add in some final text boxes to help identify some of the things being shown.\u00a0 For each of these, click to create a new Text box, then use the details below to adjust them to the right text, text box size and position.<\/p>

  1. Text: Critical Findings Summary:
    Font: Segoe UI
    Font Size: 10
    Height: 29
    Width: 177
    Horizontal: 13
    Vertical: 56<\/li>
  2. Text: Total Findings Available:
    Font: Segoe UI
    Font Size: 10
    Text Position: Centered
    Height: 76
    Width: 102
    Horizontal: 1163
    Vertical: 22
    Effects, Background: Off<\/li>
  3. Text: Your Findings:
    Font: Segoe UI
    Font Size: 10
    Text Position: Centered
    Height: 51
    Width: 126
    Horizontal: 1154
    Vertical: 109
    Effects, Background: Off<\/li>
  4. Text: Your Findings Trend
    Font: Segoe UI
    Font Size: 10
    Text Position: Centered
    Height: 30
    Width: 137
    Horizontal: 1050
    Vertical: 201
    Effects, Background: Off<\/li><\/ol>

    You should now have your full report looking similar to below:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t
    \n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    Adding More Exports and Updating Report<\/h4>

    As you want to start showing how the number of findings are changing over time, you’ll want to have more export files added into the export folder at the beginning.\u00a0 Go into Skyline Advisor as we did initially and export the files and make a note of the total number of findings.<\/p>

    Come back into your Power BI report, click the down arrow on the ‘Transform data’ link at the top of the screen and select ‘Edit Parameters’.\u00a0 From here you can adjust the file location, if you need to, and can update the total number of findings gathered from Skyline.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    With the export files in the correct folder and the figures updated, you can then click the refresh button at the top of the screen to refresh all of the visuals using the new information.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    As mentioned at the beginning this is a basic report to get you started but with this basis, you can develop the report in many different ways.<\/p>

    I’m interested to see what additional ways you may have to develop this report in the future.\u00a0 Post a comment to let me know how you get on.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

    This continues the work that we have been doing to create a basic Skyline Power BI report in part 1: https:\/\/www.virtualworlduk.co.uk\/wordp\/?p=230985 and part 2: https:\/\/www.virtualworlduk.co.uk\/wordp\/?p=231022 Build the Visuals If you’ve been following this series so far, then you will have seen us gather the data export from Skyline, create parameters and manipulate the data we took from Skyline as queries […]<\/p>\n","protected":false},"author":1,"featured_media":230988,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[9],"tags":[],"class_list":["post-231032","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-vmware"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-content\/uploads\/2022\/10\/2022-10-21-15_22_05-Skyline-Insights-1.0-Community-Power-BI-Desktop.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/posts\/231032","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/comments?post=231032"}],"version-history":[{"count":23,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/posts\/231032\/revisions"}],"predecessor-version":[{"id":231081,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/posts\/231032\/revisions\/231081"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/media\/230988"}],"wp:attachment":[{"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/media?parent=231032"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/categories?post=231032"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/tags?post=231032"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}