Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have a modified data table as seen below for a Waterfall visual. This table is set-up to have an Attributes column that contains labels, and Values column that contains corresponding numeric values. Italicized columns for ValuePaid, TotalPaidTime and ValueTotal are additional measures that I have created.
LineSK | ValuePaid | TotalPaidTime | Attribute | Value | ValueTotal |
1 | Non Operating Time | 1220 | 13.93% | ||
1 | 7540 | Total Paid Time | 7540 | 86.07% | |
1 | 14 | Maintenance | 14 | ||
1 | 138 | Changeover | 138 | ||
1 | 160 | Clean / Sanitation | 160 | ||
1 | 947.18 | Other | 947.18 | ||
1 | 6280.82 | USLE | 6280.82 |
The table is meant to power two separate Waterfall charts. As such, I have created 2 measures as follows:
LineSK | ValuePaid | TotalPaidTime | Attribute | Value | ValueTotal |
527 | 7540 | Non Operating Time | 1220 | 13.93% | |
527 | 7540 | Total Paid Time | 7540 | 86.07% | |
527 | 0.19% | 7540 | Maintenance | 14 | |
527 | 1.83% | 7540 | Changeover | 138 | |
527 | 2.12% | 7540 | Clean / Sanitation | 160 | |
527 | 12.56% | 7540 | Other | 947.18 | |
527 | 83.30% | 7540 | USLE | 6280.82 |
Solved! Go to Solution.
HI @dhkhanna,
You can try to use the following measure formula to get the percent of 'current value' divided 'total value' and group by 'LineSK'.
ValuePaid =
VAR currAttribute =
SELECTEDVALUE ( 'Waterfall Table'[Attribute] )
VAR total =
CALCULATE (
AVERAGE ( 'Waterfall Table'[Value] ),
FILTER (
ALLSELECTED ( 'Waterfall Table' ),
'Waterfall Table'[Attribute] = "Total Paid Time"
),
VALUES ( 'Waterfall Table'[LineSK] )
)
RETURN
IF (
AND (
currAttribute <> "Total Paid Time",
currAttribute <> "Non Operating Time"
),
DIVIDE (
CALCULATE (
AVERAGE ( 'Waterfall Table'[Value] ),
VALUES ( 'Waterfall Table'[LineSK] )
),
total
)
)
Regards,
Xiaoxin Sheng
HI @dhkhanna,
You can try to use the following measure formula to get the percent of 'current value' divided 'total value' and group by 'LineSK'.
ValuePaid =
VAR currAttribute =
SELECTEDVALUE ( 'Waterfall Table'[Attribute] )
VAR total =
CALCULATE (
AVERAGE ( 'Waterfall Table'[Value] ),
FILTER (
ALLSELECTED ( 'Waterfall Table' ),
'Waterfall Table'[Attribute] = "Total Paid Time"
),
VALUES ( 'Waterfall Table'[LineSK] )
)
RETURN
IF (
AND (
currAttribute <> "Total Paid Time",
currAttribute <> "Non Operating Time"
),
DIVIDE (
CALCULATE (
AVERAGE ( 'Waterfall Table'[Value] ),
VALUES ( 'Waterfall Table'[LineSK] )
),
total
)
)
Regards,
Xiaoxin Sheng
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
15 | |
13 | |
11 | |
9 | |
8 |