Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm totally new to Power BI and I'm having problems visualizing my data in a line chart.
When I choose my columns, I have the impression that my date/time isn't showing correctly.
see also attachments
Can someone point me in the right direction?
Solved! Go to Solution.
Hi @Vetex_steven ,
You can add the datetime column to AXIS field.
Then create a new table as slicer.
Table 2 = DISTINCT('Table'[datetime])
Since the min level of date range for the defult slicer is day, we need to create a measure as below and add it to visual level filter.
Measure = IF(SELECTEDVALUE('Table'[datetime])>=MIN('Table 2'[datetime])&&SELECTEDVALUE('Table'[datetime])<=MAX('Table 2'[datetime]),1,0)
You will need to select two value in the slicer (min time and max time).
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Good day everyone
When I charge my reports to Power bi report server you can't see the graphs and in some cases the tables.
Original Report
Reporte en Power Bi report server
I look forward to your support from someone, thank you.
Best regards
GM
@Vetex_steven , In both cases, I am not able so anything for value in the visual. Also in case of the date you have the option choose Date or Date Hierarchy. Right-click on the name in visual panel
Because you have added two columns (tagValue and ts) to the axis field. You can remove TagValue from the X-axis field and add a measure or decimal/whole number column to the value field. By default, date hierarchy is enabled so you will see Year level data. You can drill down to the next level to see QTR, monthly data.
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
I removed the "tagValue" from the X-axis, but still nothing 😞
see attachment,
but I do understand now what "drilling" is 🙂
@Vetex_steven You have to add column/measure into the value field.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
When I add the "TagValue" into the Values, I anly get the "total of TagValues"
I do not find a way to change this
Hi @Vetex_steven ,
You will need Axis, legend, values fields and put the column to right field.
You can manage these fields by click the dropdown menu "V".
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hello,
the problem is that when putting the column "tagvalues" in the values, it always shows me the sum of my "tagvalues" or the "count".
I cannot seem to visualize my "tagvalues" without Power BI doing a calculation on them.
edit : ok, now I understand : because I'm showing the multiple values over the course of 1 to 7 days, my only option is to show me the minimum, maximum or average value for that day!
But how do I show a line chart of the last few hours?
Hi @Vetex_steven ,
I'm not sure what you mean "show a line chart of the last few hours".
Is your axis column a date value or datatime value?
You want the axis show with hours instead of days? Or you have let's say 10 hours and you just want to show last 5 hours?
Best Regards,
Jay
hello,
my axis is a date/time value
all my values are stored each 5 seconds
I would like to show all these values in a line chart where I can choose between which time
eg between 5 am and 6 am
or zoom in more => 5:30 am and 6 am ....
Hi @Vetex_steven ,
You can add the datetime column to AXIS field.
Then create a new table as slicer.
Table 2 = DISTINCT('Table'[datetime])
Since the min level of date range for the defult slicer is day, we need to create a measure as below and add it to visual level filter.
Measure = IF(SELECTEDVALUE('Table'[datetime])>=MIN('Table 2'[datetime])&&SELECTEDVALUE('Table'[datetime])<=MAX('Table 2'[datetime]),1,0)
You will need to select two value in the slicer (min time and max time).
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |