Forum Discussion
need help with visualization and data prep.
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]))Or you also could ask other contributors in forum for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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]))
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.