Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi,
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
Hi @juanahumada,
Can you share the sample data as a table or a file?
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Portuguêshi @MFelix
Here I leave you the data that I have to make the waterfall
Let me if you can download the data please.
Regards
Juan
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
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
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
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
I have yet to use this feature, but grouping/binning might work? See below link and let me know if this works!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |