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 there,
I have a database with a list of products, with 4 steps of production, though not all products go through all steps. Each production step can be done in one of 7 locations.
What I'd like to have is something similar to a sankey diagram where I have all products flowing to each location, the difference though is that I'd like them to be step by step, so the diagram should have columns for each step.
The way it's done now is that all products get subdivided into the steps, next to each other, but not in series.
The way my database is built is that for every product, it has the associated step and the amount produced in that step. I tried pivoting the step column so that for each step i have a different column but then I had a 'null' entry that the Sankey diagram always went to instead of skipping it, and this way I could not include the locations for each step.
Any help on the matter is appreciated, and apologies if I sound a bit naive. The custom visualization I'm using is the "Tassels Parallel Sets Slicer"
Thanks in advance.
Hi @mhalabi93 ,
I am not clear about your requirement, if possible could you please inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |