Forum Discussion
Formatting Power BI Matrix
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
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!!
4 Replies
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!!
Jayee I want to display headers. if you see my top visual there are no headers. Need your help in displaying headers.
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!!
Thanks Jayee, it works
