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