Forum Discussion

davidwoodward's avatar
davidwoodward
Frequent Visitor
6 years ago
Solved

Challenge with my data in Column Chart

I have some data that looks like the following   ID Date Opened Closed 1 1-Jan 1 0 1 1-Feb 0 1 2 1-Jan 1 0 2 1-Feb 0 1 3 1-Jan 1 1 4 1-Jan 1 0 4 1-Feb ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    Is this the result you want.  Download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

There is nothing like "my example".  My solution is based on the data that you shared in your first post.  I have thereafter transformed your data in the Query Editor.  Review the solution again.

davidwoodward's avatar
davidwoodward
Frequent Visitor
6 years ago

So sorry.  Completely missed the Pivot in the Transform.  Yes, you nailed it.  Thanks much.