Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear all,
I have a problem with some missing data in my chart.
Blue bars refer to data from a direct query, and they are correct.
The others are from an excel sheet but is missing the data when i don't have data from direct query, as you can see in the picture.
Thanks for your help
Hi @Anonymous ,
We can try to create a claculated table which contain all the hours as the x-axis field to meet your requirement after create relation with the origin table
Start Of Hour Axis = ADDCOLUMNS(GENERATESERIES(0,23,1),"Start Of Month",[Value] & ":00")
If it doesn't meet your requirement, could you please share the formula of Contagem de peso if it does not contain any confidential information? Please don't have any Confidential Information or Real data in your reply.
Best regards,
@v-lid-msft there is no formula, they are just data. I just choose count to count the number of entries.
Hi @Anonymous ,
What is the data type of the "Start of Hour" column? How about the result of using the calculated table as the Sharde Axis field?
Best regards,
Someone can help me? plz
Drag the measures/field to visual level filter and put condition >0
User | Count |
---|---|
103 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |