cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
JanV Resolver I
Resolver I

Union different group by views of same table

All,

 

For the Sankey custom visual one needs a single table with following format "Origin", "Destination", "Value".

I want to create visibility on the financial relevance of a company's hierarchy (Business Unit->Division -> Area -> Branch) by showing the flow between the different hierarchy components from Business Unit -> Branch. Currently the data is in transactional format genre "1/01/2017", "€400", "Europe", "Sales", "Paris". What I currently do is creating a group by statement of the value per combination and afterwards appending all these queries in order to have a single table for the hierarchy with the Origin, Destination, Value format.

 

let
Source = AccountingSankey1,
#"Appended Query" = Table.Combine({Source, AccountingSankey2, AccountingSankey3, AccountingSankey4})
in
#"Appended Query"

 

image.pngimage.png

However this gives me a lot of queries (visual complexity) which i wouldn't need if I was able to create a single query that could capture the full complexity of the problem.

 

Any help greatly appreciated.

2 REPLIES 2
Microsoft v-ljerr-msft
Microsoft

Re: Union different group by views of same table

Hi @JanV,

"Enable Load" means query results are available for report builder. Otherwise you may use it in your other queries (for example to merge data), but it is not shown in the report builder.

According to your description above, you can uncheck the "Enable Load" option(by right click the query) for the 'AccountingSankey1', 'AccountingSankey2', 'AccountingSankey3', 'AccountingSankey4' query, then these queries can still be used for Append Query, but they won't be shown in the report view.

 

enableload.PNG

 

Regards

JanV Resolver I
Resolver I

Re: Union different group by views of same table

Hi @v-ljerr-msft,

 

Thx for your input,valuable and a good step in the right direction!! 🙂 Would still be interested to know if the "clutter" in the query view could be further reduced as well by not having to define all these views in seperate statements by combining them in a single m query.

 

Regards

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors