cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

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

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.

9 REPLIES 9
Super User

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

Frequent Visitor

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.

Super User
``differnce between these value``

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

Frequent Visitor

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

Super User

And what about Value2 and Value3 ?

Frequent Visitor

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

Super User

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

Frequent Visitor

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

Super User

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors