Get data from the microstrategy BI tool into PBI

[Syndicate_Admin]

Hello

I'm trying to integrate this data into my GDP panel, but when I do, the format changed completely and doesn't preserve the aligment of a Franchisee > Territory > Region > Metrics

I've attached some sample data in Dropbox.

All I'd like is basically to show it in the same format as my source report.

https://www.dropbox.com/scl/fi/d5ti50f9azy633oiy8hra/T30-System-by-Org_Region_Territory_TEST_PBI.xls...

[Icey · Accepted solution]

Hi @bcbuckley13 ,

Please check if this is what you want:

1. Fill down data2. Turn off "Stepped layout"3. result

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.