how to create graph between two measure columns of table visual in power bi.

[shahidmahmood]

I have the following data in the table visual .

now i want to generate a graph between rate diff % along x axis and grn amount along y axis.

[rajendraongole1 · Accepted solution]

Hi @shahidmahmood - Add a calculated column using DAX

NumericRateDiff =
SWITCH(TRUE(),
[Rate Diff %] = "up to 100%", 100,
[Rate Diff %] = "up to 50%", 50,
[Rate Diff %] = "up to 25%", 25,
0
)

Replace the conditions with actual categories present in your data.

as per snapshot, you already created measures drag the NumericRateDiff column to the X-axis.Drag the GRN Amount column to the Y-axis.

This approach will create a dynamic graph showing the relationship between Rate Diff % and GRN Amount, enabling insights into how rate differences correspond to spend.