Reply
shahidmahmood
Frequent Visitor
Partially syndicated - Outbound

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

I have the following data in the table visual .

shahidmahmood_0-1733446771442.png

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

 

1 ACCEPTED SOLUTION
rajendraongole1
Super User
Super User

Syndicated - Outbound

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.

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

1 REPLY 1
rajendraongole1
Super User
Super User

Syndicated - Outbound

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.

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)