Forum Discussion
problem visualizing in a line chart
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?
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.
11 Replies
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 🙂
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
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
