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.
Hi,
I have been trying to creat a waterfall chart where I can adjust the middle bars using a slicer to show the final bar adjusted.
Referring to the picture, I would like to adjust my slicers for margin, protection mix and volume to see changes in the graph separately. For example if I am only changing margin, the rest of the 2 should remain same but the Total bar must change accordingly.
Please let me know if it is possible to do. Thank you!
It may be possible, but without data we cannot test that. Can you share some sample data as well as the measures used in the waterfall chart? How do you adjust your slicers for margin, protection mix and volume? Which columns will be put into the slicers?
You could try adding ALLEXCEPT function to your measures to remove all filters except the specified column which is in the corresponding slicer to affect the measure.
Best Regards,
Community Support Team _ Jing
Please share sample data (not an image please) or PBIX file without confidential information and a depiction (Excel helps) of the expected outcome. Thanks!
Proud to be a Super User!
Paul on Linkedin.
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 |
---|---|
110 | |
99 | |
79 | |
64 | |
57 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |