How to group data depending the results of a mesure

[juanahumada]

Hello,

I need help with a waterfall,

I have the following waterfall but I do not want to show all the values. I just want to show just those values that are below -20 and above 20 with its name and the rest of the values I want to show them in a group called Others.

How can I to group them in just one single group and keep the others (above 20 and below -20) in its original group.

Thank you very much!
Regards,
Juan

[v-piga-msft]

Hi @juanahumada,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share some data sample.

Best Regards,

Cherry

[MFelix]

Hi @juanahumada,

On the waterfall chart use the option Breakdown to reduce the number of splits on your chart this will give you several groups just keeping the top and bottom ones the rest will go to the others option check point 6 and 7 from the documentation for this visual.

Regards,

MFelix

[juanahumada]

Hi,

@MFelix

Thank for your comment but It is not what I am looking for.

I need to group the categories (less the FX category) throught a mesure that only show me the categories that are above -20 and below 20, grouping them in a group called "others".

I left you some data for the solution of the problem.

thank you very much,

Juan

Juan

[MFelix]

Hi @juanahumada,

Can you share the sample data as a table or a file?

Regards,

MFelix

[juanahumada]

Spoiler

hi @MFelix

Here I leave you the data that I have to make the waterfall

Data Waterfall

Let me if you can download the data please.

Regards

Juan

[v-piga-msft]

Hi @juanahumada,

You may could have a try with IF function to group.

I have made a test with if, here is my formula and the test result.

Column = IF(OR([difference]>20,[difference]<-20),[difference],BLANK())

Hope this can give you some idea.

Best Regards,

Cherry

[juanahumada]

Thank you @v-piga-msft

But I need to group C, E and B in one group called "other" too.

How can I make it with and If?

Best Regards,

Juan

[v-piga-msft · Accepted solution]

Hi @juanahumada,

By my tests, you could create a custom column in Query Editor with conditional column like below.

Then you could create the visual like below.

If you still need help, could you please share your desired output?

For reference, you could have a look at the attachment.

Best Regards,

Cherry

[juanahumada]

Thank you @v-piga-msft now I can get what I want.

If I have more doubts I will write here again.

Thank again

Kind Regards,

Juan

[drewlewis15]

I have yet to use this feature, but grouping/binning might work? See below link and let me know if this works!

Grouping and Binning