Forum Discussion
Adding Additional Column in the Matrix Table for % Completion
I have created two seperate Matrix tables for %Completion because I wanted to drill through to the isssues as in the screenshot #1. Drill through was possible as I was able to use the Column from th...
Amzadkhan , Try using below steps
Go to your data table in Power BI.
Create a new calculated column using DAX (Data Analysis Expressions). The formula will be something like:
%Completion = DIVIDE([Approved], [Total])
This will create a column that calculates the percentage completion for each row in your data.
Add the Calculated Column to Your Matrix Table:
Go to your matrix table visualization.
Add the new %Completion column to the Values section of the matrix.
Ensure Drill Through Capability:
Make sure that the fields you want to use for drill through are included in the matrix table.
Configure the drill through settings to use the appropriate fields.