Power BI: I have three visuals VisualTable 1: Planned Progress Status (Columns:…
- User
Power BI: I have three visuals Visual_Table 1: Planned Progress Status (Columns: Accountable, Previous, Current, Cumulative), Visual_Table 2: Actual Progress Status (Columns: Accountable, Previous, Current, Cumulative), Visual_Table 3: Variance Progress Status (Columns: Accountable, Previous, Current, Cumulative). I need to combine these 3 to one visual Table with First Column as Item with values Planned, Actual and Variance while all others remain same.
- Assistant
To combine the three visuals into one visual Table with the first column as "Item" with values Planned, Actual, and Variance, you can follow these steps:
- Create a new table in Power BI by going to the "Home" tab and clicking on "Enter Data".
- In the "Create Table" dialog box, enter "Item" as the column name and enter the values "Planned", "Actual", and "Variance" in separate rows. Click on "Ok" to create the table.
- Go to the "Modeling" tab and click on "New Measure" to create a new calculated measure.
- In the formula bar, enter the following formula to retrieve the values from Visual_Table 1: Planned Progress Status:
Planned = SELECTEDVALUE('Visual_Table 1'[Planned]) - Create two more calculated measures for the Actual and Variance values using the same formula, replacing the table reference with 'Visual_Table 2' and 'Visual_Table 3' respectively.
- Click on the "Report" tab and add a table visual to the canvas.
- Drag and drop the "Item" column from the newly created table to the Rows section of the visual.
- Drag and drop the three calculated measures (Planned, Actual, and Variance) to the Values section of the visual.
- Now you should have a table visual showing the values from all three visuals with the "Item" column as the first column.
You can customize the visual further by formatting the columns and applying any additional formatting or calculations as per your requirements.
- User
above is not working as my table name is visual table not created table, i cannot use any table name
- Assistant
Apologies for the confusion. If you have existing tables named
Visual_Table 1,Visual_Table 2, andVisual_Table 3, you can directly reference those tables in the measures. Here are the revised steps:- Go to the "Modeling" tab and click on "New Measure" to create a new calculated measure.
- In the formula bar, enter the following formula to retrieve the values from Visual_Table 1: Planned Progress Status:
Planned = SELECTEDVALUE('Visual_Table 1'[Planned])- Similarly, create two more calculated measures for the Actual and Variance values using the same formula, replacing the table reference with
Visual_Table 2andVisual_Table 3respectively. - Click on the "Report" tab and add a table visual to the canvas.
- Drag and drop the "Item" column from the newly created table (containing values "Planned", "Actual", and "Variance") to the Rows section of the visual.
- Drag and drop the three calculated measures (Planned, Actual, and Variance) to the Values section of the visual.
- Now you should have a table visual showing the values from all three visuals with the "Item" column as the first column.
Please make sure to update the column names and measure formulas as per your actual table structure in Power BI.
- User
no sir above Planned = SELECTEDVALUE(‘Visual_Table 1’[Planned]) will not work since visual table
- Assistant
Apologies for the confusion. If your table name is "Visual_Table" and not a created table, you can directly reference it in the measure formulas. Here are the revised steps:
- Go to the "Modeling" tab and click on "New Measure" to create a new calculated measure.
- In the formula bar, enter the following formula to retrieve the values from "Visual_Table 1: Planned Progress Status":
Planned = SELECTEDVALUE('Visual_Table'[Planned])- Similarly, create two more calculated measures for the Actual and Variance values using the same formula, replacing the column references with 'Visual_Table'[Actual] and 'Visual_Table'[Variance] respectively.
- Click on the "Report" tab and add a table visual to the canvas.
- Drag and drop the "Item" column from the newly created table (containing values "Planned", "Actual", and "Variance") to the Rows section of the visual.
- Drag and drop the three calculated measures (Planned, Actual, and Variance) to the Values section of the visual.
- Now you should have a table visual showing the values from all three visuals with the "Item" column as the first column.
Please make sure to update the column references and measure formulas with the appropriate table and column names from your "Visual_Table".
- User
Still not working
- Assistant
Apologies again for the confusion. I misunderstood your initial statement. If the table names are indeed "Visual_Table 1", "Visual_Table 2", and "Visual_Table 3", here's the revised solution:
- Go to the "Report" tab and add a table visual to the canvas.
- Drag and drop the "Accountable" column from Visual_Table 1 to the Rows section of the visual. This will be the first column.
- Drag and drop the "Previous", "Current", and "Cumulative" columns from Visual_Table 1 to the Values section of the visual.
- Drag and drop the "Accountable" column from Visual_Table 2 to the Rows section of the visual. This will add a new column to the table.
- Drag and drop the "Previous", "Current", and "Cumulative" columns from Visual_Table 2 to the Values section of the visual.
- Drag and drop the "Accountable" column from Visual_Table 3 to the Rows section of the visual. This will add another column to the table.
- Drag and drop the "Previous", "Current", and "Cumulative" columns from Visual_Table 3 to the Values section of the visual.
- Now you should have a table visual combining all three visuals, with the first column as "Accountable" and subsequent columns for each visual with their corresponding data (Previous, Current, Cumulative).
- Rename the columns in the visual accordingly, such as "Visual 1 Previous", "Visual 1 Current", "Visual 1 Cumulative" for Visual_Table 1, and so on.
Please let me know if you require further assistance!
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.