Forum Discussion
Unpivot Duplicates
https://www.dropbox.com/s/zk64ewczk03mbsa/Issue_unpivot.pbix?dl=0
Hi Please find the PBIX file attached in the link above.
Find details Below:
I have on etable called Fact, I have user names the date on which they wer added and the the filed in which they work as three columns.
I need to show a trend chart on the growth of the users getting added to this table on yearly, monthly and quarterly .
the trend chart should be cumulative trend and hence i have created a measure with Max date added in filter.
Issues 1
I need to add a slicer with the values Year, Quarter,Month so that the X axis of the trend chart should change dynamicaly on the slicer selection.
I have created a copy of the table, extracted year, month quarter and then unpivoted them to get Attribute(which i can add in slicer) and Value (to add to the X axis)
Created a bidirectinal relationship also but as per PBIX i am getting wrong trend it is not taking cumaltive
Issue 2:
When i have done Unpivot not able to sort month
Issue 3 :
Need to show cumulative growth percentage also
Adding to above i cant use drill down and many to many relationship