Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All
I created a bar chart with drilldown hierachy for the X-axis with the receive date (the date on which sample is received) and going down to Receive hour (On that particular day which hour it was received). Now when i drill down in my data my receive hour on x-axis should read 0 1 2 3 4 5 6 7........23 hrs in night but it is picking the hour randomly. I have attached a pic. Can anyone please tell me how to fix this issue?
Solved! Go to Solution.
Hoi,
it looks like your hour column is a text field.
thats is why it sort like abc. first 1, 10,11 2, 21,22 etc...
change your column to a number and set the default sum to "dont summerize"
Hoi,
it looks like your hour column is a text field.
thats is why it sort like abc. first 1, 10,11 2, 21,22 etc...
change your column to a number and set the default sum to "dont summerize"
Thanks a lot maddy it worked absolutely fine. Do you think you can help me with more one thing.
I wanted to show on my dashboard the average number of tubes received daily that a receive 1.e Distinct count of my accession ID/ count of my number of receive date. So how can i write a dax for it given that i need count of dates and not number.
Really appreciate your prompt reply.
i dont realy understand what you want to count.
you want to know the average nuber of tubes you get of a day?
1-1 = 10
2-1 = 7
3-1 = 9
4-1 = 6
in this case the average would be 8.
Hi Maddy
Yes, this is exactly what i want to achieve the average number of tubes received daily.
My data has column receive date and accession id so to get average number of tubes i need a dax measure that should divide the DISTINCTCOUNT (Accession ID)/ Number of days but i dont know how to type this measure.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |