Forum Discussion

NVKSB's avatar
NVKSB
New Member
3 years ago
Solved

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 ...
Need Help
Show and Tell
Tutorial Requests
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    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's avatar
Anonymous
Not applicable
3 years ago

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