Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

dynamic axis chnage by slicer

hi team

 

i had followed the below steps to create the dynamic value by slicer with the help of belwo steps . But i think these steps are manual like creating the index and unpivoting as one time . In production how this can be run to refresh the data ?

since the unpivot table is one time this can't be refeshed on daily basis right?. And i dont have provision to create the index in fact table . unpivot can be created by using data table and union and crossfilter . But i was not able to relate the fact and unpivot table can you help me how this can be done?

 

https://community.powerbi.com/t5/Desktop/Dynamic-Category-Using-a-Slicer/m-p/216971#M96101

Need Help

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Anonymous,

     

    since the unpivot table is one time this can't be refeshed on daily basis right? In production how this can be run to refresh the data ?

    Once the source data table is refreshed, the corresponding unpivot table will be updated automatically, showing the newest data.

     

     

    unpivot can be created by using data table and union and crossfilter . But i was not able to relate the fact and unpivot table can you help me how this can be done?

    Please illustrate your scenario with some dummy data. How did you unpivot table by union and crossfilter? Please provide detailed steps so that we can reproduce.

     

    Regards,

    Yuliana Gu