Need help setting up bar chart in PowerBi dashboard

[DanGiles]

Hello, 

I am new to PowerBI and I am attempting to set up a dashboard for a work-based project, but have been having some difficulty wokring out how to present data in a specific way. The actual data I am using is sensitive so I have put together some dummy data to attempt to explain what I would like to do. 

I currently have data loaded into the Dashboard in the following format. It has a unique ID (Car_Reg), some nominal (categorical) data (Car_Size), and then the rest of the columns show whether the vehicle needs any work done using a simple yes/no (new tyres/lights, etc).

I also have the dataset below which is dependent on the data above, and uses some separate cost information to calculate the cost of any required improvements based on the vehicle size. All cells which had a 'yes' are now converted to the relevant cost, all the 'no's remain as £0.00.

In the dashboard for this data I was planning on having a bar chart which shows the overall cost of improvements for all vehicles in the database, with the type of improvement on the Y-axis, cost on the X-axis, and the car size used in the legend to break-down the data. I know how develop this chart in Excel (see below), but want to have an interactive version in my PowerBI dashboard.

What I am struggling with is that currently all of the different improvement types are in separate columns ("New_Lights?", "New_Tyres", i.e.). I also want to make sure that the data presented in the bar chart is linked to everything else so that I can click on the various elements within the bar chart to filter all of the other visualisations on the dashboard. For example, I also have a map which shows the location of each of the vehicles and it would be great if when I clicked on the the 'Large' vehicles part of the 'New Lights' bar, it would highlight all of the large vehicles which require new lights on the map.

I hope this makes sense. 

Thanks, 

Dan

[whitch]

I think you want this:

https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f5882...

Convert your separate new lights/newtyres/new paint columns into one 'work type' column using unpivot in Power Query.