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
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.