Forum Discussion
single measure for multiple data in a single column
i have a mixed data points named "Vendor values" against which it contains 200+ vendor values in the same column, but in
power bi if i want to plot individual line graph for all those vendors, then i should write multiple measures which contains 200+ measures! please guide me how to solve this problem
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
4 Replies
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 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
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 this
