Jaydis Tracker

Re: Multiple tables graphed on one line chart

Jaydis — Mon, 04 Feb 2019 13:49:45 GMT

I figured out how to make this work - I made a seperate table with all the dates and a reference number that I linked back to all the other tables. Then I graphed "Date" from that table on the axis.

Re: Multiple tables graphed on one line chart

Jaydis — Thu, 24 Jan 2019 13:47:36 GMT

Hi Anonymous,

I've created a relationship between the usernames but if I graph the count of users they all end up displaying on the same date, even if I add date columns from both tables.

See screenshot (One table is 2014, one is 2015 but they are displaying only on 2014):

Multiple tables graphed on one line chart

Jaydis — Tue, 22 Jan 2019 20:53:50 GMT

Hello,

I have multipe excel files, each containing a list of users in a system for a specific time period, which I'm importing as seperate tables. I would like to graph "count of users"(y-axis) by "date"(x-axis) on a line chart. So each table would be one data point on this chart. Is this possible to do?

P.S. I dont want to just sum the users in each file because I'd like to keep the chart interactive so I can pull up the user's names when I click on a data point.

Thanks!

Transforming sharepoint list survey results

Jaydis — Mon, 22 Oct 2018 20:13:09 GMT

Hi,

I am anaylzing results from a survey which are pulled into power bi through a sharepoint list. The format of the sharepoint list is as follows:

I would like to graph the results on a stacked bar chart - yaxis being the questions and xaxis being the % answered of each type (Excellent, good, fair, poor, n/a), also being able to filter by project #, date, manager.

I believe the easiest way to do that would be to get my data in the following format:

How would I use power bi to transform the data this way? (Or is there a better way to format the data to get the resultant graph?)

Thanks so much!