Display Quarter and Months in X axis for a data table view

[martinnilsson]

Hi,

I am new to Power BI and I have a data set that I want to display similar to the table below.  The data is showing figures per month in the X axis together with the quarters and column name (Sales Numbers).  Is this possible in Power BI.  I worked a little in Tableau and it was straightforward, just adding quarter and month fields to columns field.  Power BI looks to work differently.

Appreciate any help.

						Sales Numbers
		Q1			Q2			Q3			Q4
Customer	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
AAA	10	11	12	13	14	15	16	17	18	19	20	21
BBB	30	31	32	33	34	35	36	37	38	39	40	41
CCC	20	21	22	23	24	25	26	27	28	29	30	31
Total	60	63	66	69	72	75	78	81	84	87	90	93

-M.

[Anonymous · Accepted solution]

Thanks for the reply from vicky_ , please allow me to add some more information:
Hi  @martinnilsson ,

You can use the matrix viusal to achieve the desired result.

I created sample data:

Place [Customer] in Rows and [Date] in Columns to show the date hierarchy results and only show “Quarter” and “Month”.

Click on the yellow icon to display the full hierarchy, and here the data for [Month] will be displayed:

Visualizations –  Column Subtotals set to OFF

Visualizations – Title is set to ON：

Text – You can customize the content of the header here

Horizontal alignment – Set to center

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.

[vicky_]

The easy option (but not as performant) is to use an automatic date / time feature: https://www.sqlbi.com/articles/automatic-time-intelligence-in-power-bi/, which generates a heirarchy for you that can easily be used in your reports. If you have an existing date table, it would be easy enough to add 2 columns for qtr and month - something like:

Month = FORMAT(YourTableName[Date], "M")