Need help in generate report template by groupping measurements ( incl image)

[michaelJack]

Hi all,

I have a lot of measurement like Revenue_Actual, Revenue_LM, Revenue_Target, %Revenue,Qty_Actual, Qty_LM,Qty_Target

so it sems like to not easy to see if i put all of them under a month as table report. Could anyone has solution to help me design a report template as below, it looks easier to see.

Thanks in advanced,

 J.

[v-yuezhe-msft]

@michaelJack,

I am not sure how your table looks like, but you can try to create table as follows based on your existing data, then create a Matrix visual to show the data.



Regards,
Lydia

[michaelJack]

Hi Lydia,
It seems like to good for workaround purpose as well, so could you help to give sample code for reference to crate the table as your image? because my lowest level based on the date for each product and store. 

Thanks,
J.

[v-yuezhe-msft]

@michaelJack,

Please share sample data of your original table and share the DAX you use to create the above measures. Do mask sensitive data before uploading sample data.

Regards,
Lydia

[michaelJack]

@v-yuezhe-msft because i cannot attact the file, so i give you the link to get file from dropbox alternatively. Please help to take a look as well,
https://www.dropbox.com/s/c4y18ad8hhu9d6m/test.pbix?dl=0

Thanks,
J.

[v-yuezhe-msft]

@michaelJack,

The easiest way is to create a table visual containing all the data you need, export the table visual to CSV named testvisual, then change column names in the testvisual.csv, I save as another csv file(testv.csv) after changing column names.

After that, import the testv.csv file to Power BI Desktop, unpivot columns, split columns in Query Editor, then create Matrix. For more details, please review the uploaded PBIX file below.

https://1drv.ms/u/s!AhsotbnGu1NogwjSqm5w3tA6dR48

Regards,
Lydia

[michaelJack]

@v-yuezhe-msft thank for your help, but i think this way is really take time and require a lot of effort to do. Could you have any way to do inside power bi only, i wish it can be processed automatically.

Thanks,

J.

[v-yuezhe-msft]

@michaelJack,

It is not easy to create such new table in Power BI Desktop based on your existing table, you would need to manually change table structure in order to get expected result.

Regards,
Lydia