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
Anonymous
Not applicable

need help with visualization and data prep.

Hello everyone,

 

I have data like below in table and need visualization as shown in the image.

 

Problem also is, if a Product got delisted and new product got listed so no new rating data should apper for that product in the graph.

 

For Eg.

 

Product B0777J1KP1 got delisted on 25/04/2018 when the new product B07CN9D18C listed so ratings of the product B0777J1KP1 after this date is irrelevant.

 

 

Artikelnummer           Product         Country         Product_Coutry_Art             Aktiv             ratingCreation_dateRating_Date
10029872B0777J1KP1DEB0777J1KP1DE100298720207/11/201713/12/2017
10029872B0777J1KP1DEB0777J1KP1DE1002987203.107/11/201718/12/2017
10029872B07CN9D18CDEB07CN9D18CDE100298720025/04/201825/04/2018
10029872B0777J1KP1DEB0777J1KP1DE100298720307/11/201726/04/2018
10029872B0777J1KP1DEB0777J1KP1DE1002987202.707/11/201729/01/2019
10029872B07MCKXF9XDEB07MCKXF9XDE100298720511/01/201925/02/2019
10029872B07MCKXF9XDEB07MCKXF9XDE1002987202.911/01/201909/05/2019
10029872B07MCKXF9XDEB07MCKXF9XDE1002987202.611/01/201916/07/2019
10029872B07MCKXF9XDEB07MCKXF9XDE1002987202.411/01/201905/08/2019
10029872B07MCKXF9XDEB07MCKXF9XDE1002987202.611/01/201923/08/2019
10029872B07YSD8DMFDEB07YSD8DMFDE100298721007/10/201907/10/2019

 

 

 

 

Annotation 2019-10-31 120947_new.jpg

 

 

1 ACCEPTED SOLUTION
dax
Community Support
Community Support

Hi A31,

It is hard to analyse irregular data in Powerbi(as I know, data will aggregate automatically in chart), you could use below measure to get similar line chart or area chart, but there is no date  for 0 , so it will show a point in line chart or area chart. If you want it to show as a line, you need at least two point, you could add row in model, which should work

10029872 B07CN9D18C DE B07CN9D18CDE10029872 0 0 11/01/2019 11/01/2019

 

 

Measure = CALCULATE(SUM('Table'[rating]),FILTER( ALLEXCEPT('Table','Table'[Product]),MIN('Table 2'[Date])<='Table'[Rating_Date]&&MIN('Table 2'[Date])>='Table'[Rating_Date]))

 

 

470.PNG

 

Or you also could ask other contributors in forum for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

20191102_105337.jpg

dax
Community Support
Community Support

Hi A31,

It is hard to analyse irregular data in Powerbi(as I know, data will aggregate automatically in chart), you could use below measure to get similar line chart or area chart, but there is no date  for 0 , so it will show a point in line chart or area chart. If you want it to show as a line, you need at least two point, you could add row in model, which should work

10029872 B07CN9D18C DE B07CN9D18CDE10029872 0 0 11/01/2019 11/01/2019

 

 

Measure = CALCULATE(SUM('Table'[rating]),FILTER( ALLEXCEPT('Table','Table'[Product]),MIN('Table 2'[Date])<='Table'[Rating_Date]&&MIN('Table 2'[Date])>='Table'[Rating_Date]))

 

 

470.PNG

 

Or you also could ask other contributors in forum for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dax
Community Support
Community Support

Hi A31,

According to your description, it seems that you want show continual date? The part in blue circle will show 0?

466.PNG

And if the Aktiv =1, you need to show value till today(), right? If this is not what you want, please correct me. I need to research on it and will inform you as soon as I get it.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous
Not applicable

Hi Zoe,

 

Data in the blue circle should not appear on the graph since B07CN9D18C already has started before that. After 25-04-2018 only data for B07CN9D18C should show on the graph. and after 11th jan 2019,  B07CN9D18C should go out and B07MCKXF9X should start and continue until some new product got listed, like here we have on 01-10-2019 (B07YSD8dMF).

For the active yes we need it till today.

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.