- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

how to create graph between two measure columns of table visual in power bi.
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
Proud to be a Super User! | |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
Proud to be a Super User! | |

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
01-03-2024 11:22 AM | |||
Anonymous
| 07-08-2024 09:07 PM | ||
06-06-2024 07:43 PM | |||
05-28-2024 02:15 AM | |||
05-21-2024 02:18 AM |
User | Count |
---|---|
141 | |
117 | |
80 | |
65 | |
47 |