Choosing the right visual

[Fahd24]

Guys, I have 2 tables containing, for one, events and for the other, the updates.

Events (IdEvent*, StartDate,EndDate,Description,Amount)

Updates(IdUpdate*,IdEvent,UpdateDate,Remark)

IdEvent	Site	StartDate	EndDate	Description	Amount
1	A	26/09/2017	31/05/2018	Description1	2490
2	B	01/03/2016	24/06/2016	Description2	300
3	C	14/09/2017	31/01/2018	Description3	0

IdUpdate	IdEvent	DateUpdate	Remark
17	3	16/06/2017	-
41	1	24/11/2016	-
48	1	09/12/2016	-
50	1	21/12/2016	-
61	2	01/03/2016	-
98	1	26/12/2016	-
141	1	31/03/2017	-

These two tables are, of course, interconnected, and linked to a calendar table.

I would like to show all the data, in one visuals and I am looking for the best way to represent it.

I tried the KPI Grid by MAQ Software but it is not fully adapted to my situation since I have dates.

Help would be much appreciated.

[MAQSupport · Accepted solution]

Hello @Fahd24,

You can use KPI Grid by MAQ Software in the following way:

You can concatenate categorical columns from Table 1 using DAX, to have all this information in a single column (like Site and Description in the above image). 

You can drag the various date column from Table 2 (which has multiple values) to form the hierarchy. And the measure columns in the Measure Data bag.

Alternatively, you can also use Grid by MAQ Software as follows (or the default Table visual in a similar way):

If you wish to display only the latest update from Table 2, for every IdEvent, use the following approach in Grid by MAQ Software:

Thanks

[Fahd24]

Thanks you @Greg_Deckler, even though i did not use your solution for my situation, it will be very usefull to keep aside.

Thank you @MAQSupport, very detailled answer! I've tried you solution and it works perfectly. 

[Greg_Deckler]

Not exactly certain of what you are trying to display but with start and end dates, you may need something like GENERATE. See my quick measure here:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364

[Fahd24]

Guys, I have 2 tables containing, for one, events and for the other, the updates.

Events (IdEvent*, StartDate,EndDate,Description,Amount)

Updates(IdUpdate*,IdEvent,UpdateDate,Remark)

IdEvent	Site	StartDate	EndDate	Description	Amount
1	A	26/09/2017	31/05/2018	Description1	2490
2	B	01/03/2016	24/06/2016	Description2	300
3	C	14/09/2017	31/01/2018	Description3	0

IdProblemPropertyUpdate	IdEvent	DateUpdate	Remark
17	3	16/06/2017	-
41	1	24/11/2016	-
48	1	09/12/2016	-
50	1	21/12/2016	-
61	2	01/03/2016	-
98	1	26/12/2016	-
141	1	31/03/2017	-

These two tables are, of course, interconnected, and linked to a calendar table.

I would like to show all the data, in one visuals and I am looking for the best way to represent it.

I tried the KPI Grid by MAQ Software but it is not fully adapted to my situation since I have dates.

Help would be much appreciated.