Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Exporting issues from the URL

Hi All,

I have created one sales report based on the client requirements, earlier the year column was saperated from the table so when i am exporting the file i am only getting actual and budget sales infor not included year so i have created the column calculation where all the years is now associated with the actual budget colums which is dynamic.

The above screenshot Category Current Month are seperated from the visuls its just a text box and we dont need in exporting.

The Secound column Year and Segment are within the visual.

In Segment Actual, Budget are rows values

In Year is just one calculation columns where i am passing the years info base on the Segment.

After exporting this i am getting header actual, budget, actual budget, like that but year header are coming after last columns which is not associating.

7 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Anonymous  thanks for reply let me more clear my issue.

      I am using the Matrix Table.

      In Rows shelf = I am using 3 dimentions (Text)

      In Columns shelf = I am using one calculation column (Text) Year

      In Values = I am using 20 calculated filed (Numbers) Actual and Budget

      In columns shefl am using the calculation filed and getting output result 20 column names.

      when i am exporting am getting headers Actual and budget the columns information are coming end of the columns which is not associating.

      When its look good in the dashboard header based on the coumns filed then why its not coming header based on the dashboard.

      I have also attached the screenshots these might help you to understand the problems.

      Thanks a lots for your help.

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi Anonymous,

        Can please share a pbix file with some dummy data and keeping the raw data structure to test? It should help us clarify your structure and test to troubleshoot.

        How to Get Your Question Answered Quickly 

        Regards,
        Xiaoxin Sheng