Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
I need to create a visualization that I don't know how to do it and I haven't found a similar topic.
I have created a legend based on movement status. In the screenshot below, there are three columns (X-axis is the movement status and value is 1).
However, next to these three, I want to add a fourth column (let's call it mixed), if a movement has more than one statuses (e.g. I have three orders for the same product to three different destinations. Two of them are accepted and the third is still pending). I have created a new table with one column and one value (i.e. Mixed) and added it to the Axis field.
However, when I try to show both, PowerBI gives me the graph below instead of the one I want.
Any help is more than welcome.
Regards
Solved! Go to Solution.
Hello Neha,
Thank you for your answer.
The issue is that the "mixed" status, doesn't really exist in my data. It is a notional one based on the scenario I explained above.
I believe I have managed to do what I was looking for. I firstly created a summarised table (based on the product description in my case). Following that, I created a new column called "NewStatus". If there are orders for the same product with only one status, then I return this value. Otherwise, it returns the word "Mixed" (code below).
You should be having all the status in one column i.e accepted, Open, Pre allocated and mixed . Instead of creating a table. create one column of actual status and define what movement describe what status. And then you can use "Actual status in your axis. "
Hello Neha,
Thank you for your answer.
The issue is that the "mixed" status, doesn't really exist in my data. It is a notional one based on the scenario I explained above.
I believe I have managed to do what I was looking for. I firstly created a summarised table (based on the product description in my case). Following that, I created a new column called "NewStatus". If there are orders for the same product with only one status, then I return this value. Otherwise, it returns the word "Mixed" (code below).
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
110 | |
109 | |
94 | |
61 |
User | Count |
---|---|
171 | |
139 | |
133 | |
103 | |
86 |