Group data by date

[tjordaske]

I combine several excel sheets in Power BI. In every excel I'm having a column with the data, component, volume, ...

As result I want to have all data columns combined with the data:

Goal is to calculate totals of the volumes by data and create visuals of the number of elements (or quantities) by data.

How to solve this?

[TomMartens]

Hey,

I'm not sure if I'm missing something, but as far as I can see it's not necessary to change anything.

I assume that you already used "Append" from within the Query Editor and created 1 table, if not have a look here:

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-shape-and-combine-data/

If you are familiar with SQL, append means UNION whereas merge means JOIN.

If you have just one table, then just use the the Matrix Visual, put the Component column to ROWS the Datum column to columns and use the other columns as values.

 You also can use the Option "Show on rows" (Mark the Matrix Visual, Format -> Values -> Set Option "Show on rows" to true.

Hope this gets you started

Regards

Tom

If you want to change the layout a little

[tjordaske]

Hi @TomMartens,

This visual solves my questions, but I need this kind of grouping also in other visuals.

For example I'm trying to create a visual like this:

What's your suggestion?

[TomMartens · Accepted solution]

Hey,

create a "Clustered Column Chart" like so

Expand the hierarchy by using the symbol "Expand all down one level ..."

Finally chage the option "Concatenate ..." for the xaxis of the chart to off.

Guess this shoudl work

Regards

Tom