Forum Discussion
single measure for multiple data in a single column
1, unpivot your table to one dimension, like this
in Power Query, use this code
NewStep=Table.UnpivotOtherColumns(PreviousStepName,{"period"},"vendors","value")
2, creat a measure
TTL = SUM('SampleData'[value])3, put the measure on the y-axis, and period on the x-axis, vendors on the slicerthen can get this
Hi NVKSB ,
It is not clear exactly what the model is like. Is it possible to create a slicer using [Vendor values] and filter different Vendors through the slicer? Like this:
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Thanks for your kind reply! slicer is working but if i select multiple vendors, it will not show the line graph as comparison. also, we tried lengend option but it is not working.
Actually, i have the data in this form in the same column vendor naming from A to Z against that values entered - refer the table.
in the power Bi, i need to plot the graph with respect to all the vendors in the same line graph. for this i need to write mulitple measures in which there is a limit to include those measures in the Y-axiz of power bi line graph. now instead of writing mulitple measures how to split the lines for multiple vendors into column to visualize in power bi line graph. for example i wrote A to Z vendors, but i have 200+ vendors in columns against that values are entered.
| vendor | Values |
| V | 0.996963 |
| L | 0.054115 |
| Y | 0.255604 |
| U | 0.595632 |
| A | 0.34784 |
| Q | 0.920772 |
| O | 0.241721 |
| K | 0.410807 |
| J | 0.539064 |
| D | 0.584132 |
| Z | 0.833179 |
| E | 0.717449 |
| X | 0.196723 |
| G | 0.234181 |
| W | 0.384006 |
| N | 0.309288 |
| F | 0.059814 |
| C | 0.084645 |
| S | 0.72294 |
| H | 0.113293 |
| M | 0.166204 |
| B | 0.087546 |
| T | 0.845576 |
| P | 0.877129 |
| R | 0.956145 |
| I | 0.913694 |
actually, power bi has to split the data like this from the above column to plot the graph for comparison. but i am finding difficult to write.
| period | V | L | Y | U | A | Q | O |
| 01/01/2022 | 0.834244 | 0.087847 | 0.77775 | 0.433514 | 0.241907 | 0.832206 | 0.790484 |
| 01/02/2022 | 0.310573 | 0.061871 | 0.480452 | 0.714747 | 0.278554 | 0.31397 | 0.600749 |
| 01/03/2022 | 0.240499 | 0.784763 | 0.301731 | 0.921187 | 0.167956 | 0.145082 | 0.085129 |
| 01/04/2022 | 0.486625 | 0.352865 | 0.188694 | 0.617103 | 0.976001 | 0.711231 | 0.855793 |
| 01/05/2022 | 0.609692 | 0.305863 | 0.666351 | 0.457625 | 0.880767 | 0.342801 | 0.399002 |
| 01/06/2022 | 0.849492 | 0.438318 | 0.062549 | 0.839357 | 0.902524 | 0.816574 | 0.097438 |
| 01/07/2022 | 0.405052 | 0.034935 | 0.443812 | 0.365386 | 0.295951 | 0.006174 | 0.721441 |
| 01/08/2022 | 0.160208 | 0.534335 | 0.369566 | 0.037019 | 0.932584 | 0.306466 | 0.554775 |
| 01/09/2022 | 0.551873 | 0.156081 | 0.979421 | 0.24038 | 0.294137 | 0.686873 | 0.569841 |
| 01/10/2022 | 0.161003 | 0.431247 | 0.665505 | 0.202353 | 0.954219 | 0.25221 | 0.985219 |
| 01/11/2022 | 0.191255 | 0.212066 | 0.380732 | 0.600485 | 0.08384 | 0.352086 | 0.199621 |
| 01/12/2022 | 0.236224 | 0.306644 | 0.445889 | 0.92918 | 0.400317 | 0.964224 | 0.561808 |
| 01/01/2023 | 0.416367 | 0.235931 | 0.381062 | 0.603295 | 0.154134 | 0.320166 | 0.773025 |
| 01/02/2023 | 0.304844 | 0.726367 | 0.475599 | 0.361387 | 0.926058 | 0.309167 | 0.832495 |
| 01/03/2023 | 0.340988 | 0.025516 | 0.113515 | 0.542912 | 0.721275 | 0.207058 | 0.559285 |
| 01/04/2023 | 0.683527 | 0.191696 | 0.805965 | 0.618789 | 0.894897 | 0.590346 | 0.891981 |
| 01/05/2023 | 0.868325 | 0.310913 | 0.405146 | 0.702153 | 0.752957 | 0.409898 | 0.134553 |
| 01/06/2023 | 0.59391 | 0.08452 | 0.560182 | 0.760357 | 0.380791 | 0.443715 | 0.57491 |
| 01/07/2023 | 0.090358 | 0.231391 | 0.248679 | 0.498478 | 0.144097 | 0.963654 | 0.819901 |
i tried this code, Vendor A = IF [Vendor values] = "Vendor A", [Value], BLANK()
Vendor B = IF [Vendor values] = "Vendor B", [Value], BLANK()
but the problem is for 200+ vendors i need to write the mesures and link in the Y axis of line graph.
problem statement: in a column, i have mulitple vendor and in the other column, I have values entered against that, how to map individual vendors with respect to individual line graph.
Please help me with a solution.
Thank you,
NVKSB
1, unpivot your table to one dimension, like this
in Power Query, use this code
NewStep=Table.UnpivotOtherColumns(PreviousStepName,{"period"},"vendors","value")
2, creat a measure
TTL = SUM('SampleData'[value])3, put the measure on the y-axis, and period on the x-axis, vendors on the slicerthen can get thisHi NVKSB ,
Try pivoting the [vendor] column in the PowerQuery editor.
Suppose we have:
Select the [vendor] and pivot column
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum