Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Set graph values dynamically on dataset change

Hi,   I don't know if this could be done with PowerBI or not. when I try to create a graph like a line graph : I always set the graph values from PBI UI :   what I want to do is not...
Need Help
  • artemus's avatar
    artemus
    6 years ago

    If you unpivot your data such that there is one row per sensor with a column that has the sensor name. You can put the sensor value in the values of the visual and sensor name column in the legend.

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi, 

     

    So I tried unpivoted my data just like you suggested.

    and it worked after I add some more tweak.

     

    for references:

    1. I import my original data without unpivot it

    2. I create another power query and this time I add unpivot process and get my unpivoted data

    3. after I create both of these tables, I connected both of their models and set the connection into both ways.

    4. then I mapped my unpivoted data into my graph,

    • Time as Axis
    • Value as Values
    • Attributes as Legends 

     

    with this, my graph could add and remove its values dynamically.

     

    thank you

artemus's avatar
artemus
Microsoft Employee
6 years ago

If you unpivot your data such that there is one row per sensor with a column that has the sensor name. You can put the sensor value in the values of the visual and sensor name column in the legend.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Artemis,

     

    thank you for your reply.

    when you said unpivot my data, does it means to change my data from:

    timesensor1sensor2
    10001
    20012

     

    to this?

    col1col2col3
    time100200
    sensor101

     

    if yes, I think I could do it, but still I don't understand how to map these data without me selecting it manually from PowerBI UI. s

    • artemus's avatar
      artemus
      Microsoft Employee
      6 years ago

      I mean your data should look like:

      timesensor namesensor value
      100sensor10
      100sensor21
      200sensor1

      1

      200sensor2

      2

       

      Then put "sensor name" into legend and "sensor value" into values

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi, 

         

        So I tried unpivoted my data just like you suggested.

        and it worked after I add some more tweak.

         

        for references:

        1. I import my original data without unpivot it

        2. I create another power query and this time I add unpivot process and get my unpivoted data

        3. after I create both of these tables, I connected both of their models and set the connection into both ways.

        4. then I mapped my unpivoted data into my graph,

        • Time as Axis
        • Value as Values
        • Attributes as Legends 

         

        with this, my graph could add and remove its values dynamically.

         

        thank you