Formatting Power BI Matrix

[ven-bodempudi]

Hi Everyone,

i have below requirement.

Above is the Matrix Visual, hour is in columns and sales in values. Data is being displayed correctly. Now our expection is below.

PickedHour	12:00 AM	1:00 AM	2:00 AM	3:00 AM	4:00 AM	5:00 AM	6:00 AM	7:00 AM	8:00 AM	9:00 AM	10:00 AM	11:00 AM	12:00 PM	1:00 PM	2:00 PM	3:00 PM	4:00 PM	5:00 PM	6:00 PM	7:00 PM	8:00 PM	9:00 PM	10:00 PM	11:00 PM
PickersNeeded	10	20	30	40	50	60	70	80	90	100	110	120	130	140	150	160	170	180	190	200	210	220	230	240

Can you please suggest  me how to do it?

Thanks

Venkat

[ven-bodempudi]

Thanks Jayee, it works

[Jayee · Accepted solution]

@ven-bodempudi 

Oh you need "PickedHour" and "PickersNeeded" in the chart two possibilities we have

1) Add a text box and write the name and show by arranging.

2) Create a calculated column in the table named "PickedHour" and value is "PickersNeeded" and add this in Row fields of matrix visual.

PickedHour = "PickersNeeded"

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!

[ven-bodempudi]

@Jayee I want to display headers. if you see my top visual there are no headers. Need your help in displaying headers.

[Jayee]

Hi @ven-bodempudi ,

You want to display hour's in AM/PM insted of 24hrs format.

This need to be done in field itself change the format of field it will reflect in Matrix.

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!