Having trouble make a matrix visualization with column headers that use multiple columns and dates

[Daryn-TP]

So I have a data set that looks similar to the following:

I need to make a table or matrix visualization that breaks down each availability category (110m, 1G, etc.) by date. It should look similar to the following:

If I drag each availability column to the column section it just gives me columns based on the values within the column rather than just labeling the column "Available 100M" for instance. How can I build out a visualization like the one above?

Thank you for your assistance!

[littlemojopuppy · Accepted solution]

Hi @Daryn-TP.  I'd adjust your data model so that what you are currently showing in separate fields of 100M, 10G and 25G are a category field with values of 100M, 10G and 25G.  That way when you drop that category into the matrix it will allow you to expand and show them.  You can easily do this in the Power Query Editor with Unpivot Columns.  Hope this helps!

[Anonymous · Accepted solution]

Hi  @Daryn-TP ,

Here are the steps you can follow：

1. Enter the power query, select [Avaliable 100M], [Avaliable 10G], [Avaliable 25G], and click Transform – Unpivot Columns.

Result：

2. Open the Matrix visual and place it as follows.

3. Click the button.

Result：

Best Regards,

Liu Yang

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

[littlemojopuppy · Accepted solution]

Hi @Daryn-TP.  I'd adjust your data model so that what you are currently showing in separate fields of 100M, 10G and 25G are a category field with values of 100M, 10G and 25G.  That way when you drop that category into the matrix it will allow you to expand and show them.  You can easily do this in the Power Query Editor with Unpivot Columns.  Hope this helps!