single measure for multiple data in a single column

[NVKSB]

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

[Anonymous]

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

[NVKSB]

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

[wdx223_Daniel · Accepted solution]

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 slicer

then can get this

[Anonymous]

Hi @NVKSB ,

Try pivoting the [vendor] column in the PowerQuery editor.

Suppose we have:

Select the [vendor] and pivot column

Pivot columns

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