Forum Discussion
How to get Power Bi to recognize and plot multiple data points in the same time frame
Ok, almost there!
Lastly, my data is a running data set, meaning I started tracking on June 15th. I understand that I can use the Slicer function to brake the data into months, is there a way to see the data set in its entirity, right now it looks like it is limited to 30 days.
Thanks for all the help, much appreciated!
CincyKidd
Not quite sure why you'd like 19 lines, data in report usually gets aggreaged instead. However some trick with RANKX can help to get 19 lines instead of 7.
Check more details in the attached pbix.
If it solves your problem, please accept it as solution. For more questions, feel free to let me know.
Eric- Thanks for the help, it looks like this might be the trick I was looking for, I will test it out later today and give a report.
By the way, I asked for the split instead of sum so I can look at specific performance. Now I will have the ability to look at combined performance or look at individual.
More to come and thanks again.
CincyKidd
Ok, two things.
1) what is the significance of the "Index" column?
2) how would I go about putting in the "Rank" column? I see there is code associated with the column.
Thanks.
CincyKidd
1) Index Column, give you starting to 0 or 1 a consecutive value to every row of your data table.
you can create this in Edit Query.
Creating an index starting to 0
2) Rank: this is the dax formula, its take in this case the index column and ranked in ascending. (1,2,3, etc)
Create a calculated column and put this:
Rank = RANKX(all('TableName');'TableName'[index];;ASC)
An you can create by this way:
New Column in the table and put this dax formula
