topic Re: I am working on creating a Waterfall chart based on the word visual. It is possible or not. If h in Developer

I am working on creating a Waterfall chart based on the word visual. It is possible or not. If how?

Rajeshcric424 — Mon, 01 Apr 2024 07:24:54 GMT

I have data like below.

ID	Value1	Value2	Value3
S-2024012903103	55.44	7.74	3.37
S-2024012903104	56.29	7.67	5.76
S-2023081802986	7.76	32.75	55.42

I have sample data like above in my report. I need to show this data like in below visual.

What am trying to do in my visual is want to see the subtracted difference between two IDs for value1, value2, value3.
If selected ID column it is getting all the IDs in it. But I want see subtracted difference between ID. How show this for value1, value2, value3. If differnce is positive it need go above and green. if it is negative need go below and show in red.

Any suggestions and inputs are helpful and I want to know is is possible in power Bi or not. If not possible why? Thanks.

Re: I am working on creating a Waterfall chart based on the word visual. It is possible or not. If h

lbendlin — Sun, 31 Mar 2024 22:02:53 GMT

Please be more specific. What are you subtracting from what?

Re: I am working on creating a Waterfall chart based on the word visual. It is possible or not. If h

Rajeshcric424 — Mon, 01 Apr 2024 07:36:09 GMT

ID column is the distinct column.

For exmaple I have three fields for DI Column S-2024012903103

55.44

7.74

3.37

Need to subtract from the ID S-2024012903104

56.29

7.67

5.76

this differnce between these values need to shown in the visual for any two id when selected.

Re: I am working on creating a Waterfall chart based on the word visual. It is possible or not. If h

lbendlin — Mon, 01 Apr 2024 11:41:11 GMT

differnce between these value

I don't know what that means. Please show a sample calculation

Re: I am working on creating a Waterfall chart based on the word visual. It is possible or not. If h

Rajeshcric424 — Mon, 01 Apr 2024 12:46:52 GMT

For ID S-2024012903103 Value1 is 55.44

For ID S-2024012903104 Value1 is 56.29

When user select first S-2024012903103 and second S-2024012903104
55.44 - 56.29 = -0.85 need to be showed in the visual in red below the 0 going down. If positive need show above the axis in green.

for that onyl i have added a refrence visual how the output need to looked

Re: I am working on creating a Waterfall chart based on the word visual. It is possible or not. If h

lbendlin — Mon, 01 Apr 2024 13:11:52 GMT

And what about Value2 and Value3 ?

Re: I am working on creating a Waterfall chart based on the word visual. It is possible or not. If h

Rajeshcric424 — Mon, 01 Apr 2024 20:10:37 GMT

Need to do for all value1, value2, value3. I just showed for value1

Re: I am working on creating a Waterfall chart based on the word visual. It is possible or not. If h

lbendlin — Mon, 01 Apr 2024 20:14:47 GMT

I don't know how to visualize that. Please show expected outcome based on your sample data.

Re: I am working on creating a Waterfall chart based on the word visual. It is possible or not. If h

Rajeshcric424 — Tue, 02 Apr 2024 06:43:37 GMT

Please find below If the Subtrcted is postive or need show like below.

Re: I am working on creating a Waterfall chart based on the word visual. It is possible or not. If h

lbendlin — Tue, 02 Apr 2024 19:42:13 GMT

I cannot assist you as I don't understand the issue. I hope someone else can help you further.