Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Vetex_steven
Frequent Visitor

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?

 

powerbi - 2.PNGpowerbi.PNG

1 ACCEPTED 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])

13.PNG

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).

14.PNG

15.PNG

 

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.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

11 REPLIES 11
Syndicate_Admin
Administrator
Administrator

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

Gerardowmq_1-1625678321012.png

Reporte en Power Bi report server

Gerardowmq_0-1625678230042.png

I look forward to your support from someone, thank you.

Best regards

GM

amitchandak
Super User
Super User

@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

nandukrishnavs
Super User
Super User

@Vetex_steven 

 

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
🙂


Regards,
Nandu Krishna

I removed the "tagValue" from the X-axis, but still nothing 😞

 

see attachment,

 

but I do understand now what "drilling" is 🙂powerbi - 3.PNG

@Vetex_steven  You have to add column/measure into the value field.

 

 

Capture.JPG



Did I answer your question? Mark my post as a solution!
Appreciate with a kudos
🙂


Regards,
Nandu Krishna

When I add the "TagValue" into the Values, I anly get the "total of TagValues" 

I do not find a way to change this powerbi-4.PNG

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".

1.PNG2.PNG

 

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.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

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])

13.PNG

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).

14.PNG

15.PNG

 

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.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.