Forum Discussion
Choosing the right visual
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
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.