Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, everyone my information are decale for some secondes so I try to round the number of time at the day so the information are the same but I've a multiple time the same informations:
as you can see , I want to have 18/12/2018, fab1 submitter=11 I don't know what to do so please help!
Solved! Go to Solution.
I am glad that it worked.
if there is a way to have this information to all of the last information that I have :
In this scenario, do the following:
Hope this helps!
Rgds,
Vivek
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thank's it work but do you know if there is a way to have this information to all of the last information that I have :
can I allsaw have the last information before I use the group fonction witch are :
I am glad that it worked.
if there is a way to have this information to all of the last information that I have :
In this scenario, do the following:
Hope this helps!
Rgds,
Vivek
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
even If I do that because it's not exactly the same time it didn't show me the count of the line and I want to have an approximation of the time count by submitter
You may apply the transformation on the first column: Select the column > Transform > Date > Date Only
and then do the Group By
Or, share the sample data file.
Rgds,
Vivek
Hi,
I believe you need to do some data transformation. You may refer to the pbix file here
Thanks,
Vivek
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@almanacht Under values section of Visualizations Pane, click on the down arrow of the field (that you want to count) and then select "COUNT" something similar to below screenshot
Proud to be a PBI Community Champion
thank's for you're response but I don't have that I've got a french version of PowerBi but I can describe to you what I see, their is none count or "compter" in french in my visualisation as you can see :
hi @almanacht ,
If I am not mistaken, count can be seen in Values section. Not in Axis section
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |