cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

dyamic axis implementation - help needed

hi team i am in the process of implementing dynamic axis change with the help of sclier chichlet . My scenerio is in below manner :

 

i have factsales with 60 million reocords and i have the granularity in below way :

 

prodctname customername date sales

 

a   aasd  10/22/2018   500

b  add    10/21/2018   400

b  add    10/21/2018   300

c   addd  10/19/2018   200

 

i created the index and selected the columns that are required and unpivoted it  where now i have like 60milllion *3 times . can you let me know if there is any option do it  without unpivoting it?

 

since i need the directionraltionship with the above table i need the index that i am creating in power bi . So should i create the index in database and then proceed .currently i have many to one realtioship with above table and unpivot table .

 

https://www.youtube.com/watch?v=n-OWNaCUU0o&t=311s  . I have taken this video for base for my example

 

2 REPLIES 2
Super User
Super User

Re: dyamic axis implementation - help needed

Hey,

 

can you please create some sample data (original and unpivoted) and upload this data to onedrive or dropbox.

 

Regards,

Tom

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!

Re: dyamic axis implementation - help needed

 hi @TomMartens

https://www.dropbox.com/s/5iv6gtp1u68pq1i/FinalStructue2.xlsx?dl=0

 

This is the sample data with 10 rows . I have the fact with dimension values (i created the tab like dimvalues) .

 

So i need the measures to be sliced with feedyard,rationname and sex .

 

 

steps i followed:

 

created the index for fact in power bi. (fact table daily load from SQL)

copied the table with 3 selected columns and unpivoted it .

this made me to have the relationship with the fact and unpivoted table .

 

questions:

 

1) If i dont have the index in source and if my data refreshes on daily basis . index can be added at power bi?.

2) The table of unpivoted i created for one time which may not be correct right . If the values in fact table adds up new y unpivoted table should also chnage accordingly .right?.how this can be achived for prod.

 

your help is highly appreciated . Let me know like condiations if need to have key in fact at SQLDW (etc., for better modelling)