Solution not able to display bar chart in Power BI with percentages from 3 quarters. I…
- User
Solution not able to display bar chart in Power BI with percentages from 3 quarters. I have 3 tables Quarter 1 Quarter 2 and Quarter 3. I need to display the column Score from each table which has percentages as bar chart to compare, filtered by Column Code value = "Engineering Scorecard" from each table how is it possible in single chart
- Assistant
To create a bar chart in Power BI with percentages from 3 quarters, follow these steps:
-
First, ensure that you have imported all three tables (Quarter 1, Quarter 2, and Quarter 3) into Power BI.
-
Create a relationship between each table's "Column Code" column and set it as the active relationship. This will allow us to filter the data based on the common "Column Code" value.
-
Go to the "Visualizations" pane in Power BI and select the stacked bar chart.
-
Drag the "Score" column from each table onto the "Values" field well in the "Visualizations" pane to create three separate "Score" measures.
-
Drag the "Quarter" column from each table onto the "Axis" field well in the "Visualizations" pane. This will help us compare the scores across different quarters.
-
Drag the "Score" column from any of the tables onto the "Legend" field well in the "Visualizations" pane. This will create a separate bar for each table.
-
Drag the "Column Code" column from any of the tables onto the "Filters" field well in the "Visualizations" pane and set the filter to include only "Engineering Scorecard".
-
To convert the scores into percentages, you can create a calculated column. Go to the "Fields" pane, right-click on the table containing the "Score" column, and select "New column". Use a formula to convert the "Score" into a percentage format, such as [Score] * 100.
-
Replace the "Score" column in the "Values" field well with the new calculated column for each table.
-
Finally, customize the appearance of the bar chart as desired, including adding axis titles, data labels, and adjusting color schemes.
By following these steps, you should be able to create a single bar chart in Power BI that displays the percentage scores from each quarter's table, filtered by the "Engineering Scorecard" value in the "Column Code" column.
-