Forum Discussion

Zen's avatar
Zen
Regular Visitor
8 years ago

Graph With Dates

Hello everyone,   I am a new BI user and I have having trouble with a graph.   I have a datasheet with four columns.   Each column is named Letter 1, Letter 2, Letter 3 and Letter 4.   In eac...
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Zen,

 

You can unpivot these column. Then the visuals could be easy. You can try it out in this demo.

Graph_With_Dates

Graph_With_Dates2

 

Best Regards,

Dale

 

  • Zen's avatar
    Zen
    Regular Visitor
    8 years ago

    Thanks Dale but (unless I did something wrong) this didnt work. Maybe it has to do that there are other data in the datasheet also?

     

    I have uploaded a mini example of the datasheet https://files.fm/u/nvnb8bgz in case you want to get a better understanding.

  • Zen's avatar
    Zen
    Regular Visitor
    8 years ago

    Thanks v-jiascu-msft Dale but (unless I did something wrong) this didnt work. Maybe it has to do that there are other data in the datasheet also?

     

    I have uploaded a mini example of the datasheet https://files.fm/u/nvnb8bgz in case you want to get a better understanding.

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      8 years ago

      Hi Zen,

       

      Please check out the demo here.

      Graph_With_Dates3

       

      Best Regards,

      Dale