Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
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
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!!
@Jayee I want to display headers. if you see my top visual there are no headers. Need your help in displaying headers.
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!!
User | Count |
---|---|
85 | |
74 | |
71 | |
68 | |
56 |
User | Count |
---|---|
96 | |
94 | |
92 | |
78 | |
71 |